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 “affair” 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.

129 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
affair123435(None) 
affaire1344461affaire
affairs1334161affairs
afar76720782a_fa_r
affaires1444302affaires
affirm1435522aff_irm
affix1836002aff_ix
afraid1049712afraid
fair76332522__fair
flair86114122_flair
kaffir16345302kaff_ir
unfair936232unfair
zaffar21385042zaffa_r
zaffir21395512zaff_ir
acari75020283a_cari
afars85716513a_fars
afeard1058263afeard
aff95537613aff___
affable15117403affable
affably1855183affably
affect1448903affect
affiant1348433affiant
affine12310503affine
affirms1534383aff_irms
affixer2033913affixer
afflict1547043afflict
afflux1942793afflux
afford1346493afford
affray1534973affray
affrayer1742693affrayer
affrays1644063affrays
afire86215913a_f_ire
aflame1138723aflame
afrit8323173a_frit
after85719793a_fter
again65218113a_gain
agar58726413a_ga_r
agnail739523agnail
air38058393___air
ajar116217703a_ja_r
alar46340073a_la_r
alcaic1039983alcaic
alfa77624273alfa__
alfaki1385383alfaki
alfakis1475073alfakis
alfas87219043alfa_s
altar55520643alta_r
amain74922883a_main
ambari103012153ambari
amir65129743a__mir
anear55420323anea_r
antiair7310313antiair
antiar6317173antiar
assai5711543assai_
assail6610153assail
assais6711963assais
astir55517093a_stir
attain6311753attain
attar56516693atta_r
atwain937813atwain
aurar54420253aura_r
avail8313883a_vail
await85524493a_wait
baffler15418113baffler
caffein1535333caffein
chair105519633_chair
daffier1457833daffier
deair65817193_deair
eclair836813eclair
efface14366673efface
effacer15255413effacer
fail74840243__fail
fain75840563__fain
fairs85825443__fairs
fairy115318283__fairy
fakir125111493_fakir
faqir17548643_faqir
faquir1834313faquir
far67762603__fa_r
fear75337793_fea_r
fiar76427333_fia_r
fir66744893__f_ir
flail85316183_flail
flairs95711913_flairs
flir76422203__flir
frail85220213_frail
friar85414273_friar
funfair1342033funfair
gaffer134310133gaff_er
glair65313553_glair
haffit1538533haff_it
hair76330143__hair
iffier1236753iffier
impair1035993impair
kaffirs17325553kaff_irs
kafir12488903kaf_ir
kefir12457913kef_ir
lair45934153__lair
maffia14327203maff_ia
maffias15327283maffias
maftir1136493maftir
mair66133763__mair
midair937983midair
mohair1135203mohair
offal1136243offa_l
offals1235893offals
offer114311383off_er
pair66031513__pair
parfait12312053parfait
raffia12287703raff_ia
raffias13237713raffias
raffler13339223raffler
repair84011463repair
safari91110223safari
sofar86115493sofa_r
stair54719933_stair
suffari1345503suffari
taffia12286903taff_ia
taffias13377413taffias
taffrail1442353taffrail
unhair937333unhair
vair75624143__vair
waffie15338563waff_ie
waffler16377783waffler
wafflier1733953wafflier
wair75830053__wair
zaffars22325233zaffars
zaffer21397153zaff_er
zaffirs22375663zaff_irs

Search took 8 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161297.36015314.7
3Display Results1291290.0801612.5
 (SQL Overall)1786911297.56323627.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.