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 “fustian” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
fustian103690(None) 
fustians1146401fustians
dustman1044682dustman
dustpan1043242dustpan
fusain958642fusai_n
fusion939772fus_ion
fustic11910632fusti_c
fustics1279592fustics
fustier104213932fustier
fustily133111372fustily
sustain738772sustain
abstain947253abstain
auction93412933auction
austral73411513austral
bastion9312473bastion
bestial9311643bestial
bushman1455693bushman
buskin123811493buski_n
busman10310253bus_man
bustic101012693busti_c
bustics11810883bustics
bustier93916153bustier
busting104221793busting
countian1048123countian
curtain9319793curtain
cushion1236403cushion
custodian1243763custodian
cutin75022783cu_ti_n
destain8412083destain
distain8313783distain
durian7312003du_rian
dustbin1044543dustbin
dustier83814133dustier
dustily113211523dustily
dusting93618993dusting
dustmen1035773dustmen
dustpans1143233dustpans
dustrag945363dustrag
faction122613333faction
fascia1148703fascia_
fasciae1247523fasciae
fascial1258303fascial
fascias1258413fascias
fashion1337843fashion
fasten95114893fast_en
fasting114522833fasting
festal94213563fest_al
festival1444713festival
festive1339773festive
festoon1037673festoon
fetial95716193f_etial
fiction122010733fiction
fission1038733fission
fistic11812573fisti_c
fisting113818123fisting
fontina1038633fontina
footman1236403footman
fountain1144923fountain
fruition11106103fruition
frusta937453frust_a_
function1337843function
funkia1336343funkia_
funkias1435383funkias
furan84320013fu__ran
furtive1337173furtive
fusains1038363fusains
fusaria1046223fusaria_
fusil84715323fus_i_l
fusile94313493fus_ile
fusils93912343fus_ils
fusing104415953fus_ing
fusions1039153fus_ions
fussier103610673fussier
fussily13267603fussily
fussing113611683fussing
fustiest113014573fustiest
fustigate1345623fustigate
fusty115016513fust__y
fusuma1134503fusuma_
futile93914953fu_tile
futon83113773fu_t_on
gentian8310103gentian
gustier83813863gustier
gustily113010903gustily
gusting93917163gusting
hessian1035853hessian
justice1637423justice
justify2034663justify
justing153615163justing
lesbian944463lesbian
lustier73813503lustier
lustily103611243lustily
lusting83619323lusting
lustra6358893lustra_
lustral7339653lustral
martian93514683martian
mesian84315503mes_ian
muntin82915183munti_n
musician1246693musician
muslin8312213musli_n
mustang10267933must_ang
mustier94017963mustier
mustily123613633mustily
musting103221073musting
nuptial946633nuptial
ostia52315583_ostia_
ousting84021353ousting
outman83115033ou_tman
outran63218893ou_tran
outsin63617563outsi_n
outspan938743outspan
pastina93914593pastina
postin83521033posti_n
postman112410043postman
puritan939283puritan
question1745823question
ruction93611613ruction
ruffian1344133ruffian
rustic8712673rusti_c
rustical1048393rustical
rustics9810733rustics
rustier74416363rustier
rustily103112993rustily
rusting83821263rusting
rutin55421343ru_ti_n
sestina72711973sestina
stain55727943__stain
suction93713043suction
sultan63012593sult_an
suntan62613003sunt_an
sustains838553sustains
tertian7511193tertian
titian62512663_titian
tuition738823tuition

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.1561145455.1
2DLD Change Limit1340271346.44020811.6
3Display Results1341340.0462913.0
 (SQL Overall)1786911346.64226903.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.