Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “frisson” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
frisson104531(None) 
frissons1145041frissons
caisson936592caisson
crimson1135642crimson
fission1038732f_ission
foison948932foi_son
grison7310102gri_son
orison6411662ori_son
prison8514022pri_son
arioso64312403arioso_
ariosos7409853ariosos
arisen65316793ari_sen
aristo6414033aristo_
aristos7312383aristos
arson55118833ar__son
bison75716983_bi_son
bridoon1046203bridoon
briss75824273briss__
brisses94314313brisses
bristol937043bristol
caissons1036283caissons
chrismon1544643chrismon
classon937693classon
crimsons1245633crimsons
crispen11348203crispen
crissa837623criss_a
crissal937413crissal
crissum1144843crissum
derision939073derision
elision72311103elision
emission1047673emission
erasion7311963erasion
erosion7311123erosion
fissions1138033f_issions
foisons1047613foi_sons
frass85321123frass__
frasses104314513frasses
fresco1136473fresco_
frescos1236813frescos
freshen133010883freshen
friction1347913friction
fries85535603fries__
frigs96019273frigs__
frijol1634123fri_jol
frisbee12298513frisbee
frise85322453fri_s_e
frisee94217993fri_see
frisees104411693frisees
frises94124273fri_ses
friseur1033673friseur
frisk125312373fri_s_k
frisked15478823frisked
frisker14389273frisker
frisket143811773frisket
frisking16268363frisking
frisks13479263fri_sks
frisky16406673fri_sky
frits86129103frits__
frivol1235113fri_vol
fronton1037203fronton
fruition11106103fruition
furioso1044323furioso_
fusion939773f_usion
gibson935123_gibson
griffon1443103griffon
griskin1236013griskin
grisons838993gri_sons
lesson64412043_lesson
lewisson1142023lewisson
lissom837403_lissom
mission9312743_mission
omission1046533omission
orisons7310563ori_sons
piston83515923_piston
poison8312223poi_son
pressor93512883pressor
prion75119993pri__on
prisons9313223pri_sons
priss74623893priss__
prissed103311263prissed
prisses94816713prisses
prissing113011453prissing
prissy11347853priss_y
ramson8310463_ramson
reason62616333_reason
ribbon1036533_ribbon
risen54621883_ri_sen
rissole739783_rissole
scission1045563scission
scissor994123scissor
treason748763treason
trigon74513103tri_gon
triton63914893tri_ton
unison649033uni_son
vision9311313_vision
warison1037083wari_son

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.420425454.8
2DLD Change Limit134027966.11021935.7
3Display Results96960.0462087.0
 (SQL Overall)178691966.57627173.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.