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

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

107 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
fairy11531828(None) 
airy75734161_airy
dairy97016301dairy
faery116015481faery
fair76332521fair_
fairly125610011fairly
fairs85825441fairs
hairy115316831hairy
aery77231682_aery
afire86215912afire
air38058402_air_
airn46433842_airn
airs46447432_airs
airt45757792_airt
awry107619682_awry
bairn77515532bairn
caird85717232caird
cairn75717512cairn
cairny11557822cairny
carry105823782carry
daily95922332daily
daisy95915312daisy
diary95016972diary
faddy135511622faddy
faggy136514372faggy
fail74840242fai_l
fails85631482fails
fain75840562fai_n
faint85837062faint
faired105915772faired
fairer95212062fairer
fairway1644332fairway
faith115620852faith
fakery16509262fakery
fakey155515422fakey
fakir125111492fakir_
fakirs13468082fakirs
family143311702family
fancy134615482fancy
fanny114816042fanny
faqir17548642faqir_
faqirs18456032faqirs
far67762602fa_r_
farcy135217092farcy
fard85639062fa_rd
fare76354462fa_re
farl76338552fa_rl
farm95934542fa_rm
faro76136922fa_ro
fart76860562fa_rt
fatly115716802fatly
fatty115117412fatty
fawny144711712fawny
fay97454862fa__y
ferry116020802ferry
fiar76427342fiar_
fiars86720832fiars
fiery114714792fiery
fir66744902f_ir_
fire76245602f_ire
firm96026462f_irm
firn76927512f_irn
firry115713532firry
firs76637722f_irs
flair86114122flair_
flairs95711912flairs
flir76422202flir_
flirs85518932flirs
flirt87424752flirt
flirty12499142flirty
friary124010092friary
fry96226502f__ry
furry116719282furry
fury107727972f_ury
gaily95020972gaily
glairy10448272glairy
hair76330142hair_
hairs86225172hairs
harry115322952harry
kaury12429762kaury
lair45934152lair_
laird65417792laird
lairs55425872lairs
laity85318902laity
mair66133782mair_
mairs76228302mairs
marry104821692marry
miry96326762_miry
naira5314742naira
nairu5413812nairu
nary76931222na_ry
pair66031512pair_
pairs75325832pairs
parry105323752parry
rainy85921082rainy
saury84317222saury
spiry105017352spiry
tarry85422512tarry
vair75624142vair_
vairs85019132vairs
vary105226062va_ry
wair75830052wair_
wairs86424062wairs
wary106740012wa_ry
wiry106422842_wiry
yaird96111912yaird
zaire14311992zaire

Search took 3 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 Filter178691538000.346516448.0
2DLD Change Limit538001071.79629955.5
3Display Results1071070.0303566.7
 (SQL Overall)1786911072.17282270.3
 
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.