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

113 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
affairs133416(None) 
affair1234351affair_
affaire1344461affaire
affaires1444301affaires
afars85716512a_fa_rs
affirm1435522aff_irm
affirms1534382aff_irms
fairs85825442__fairs
flairs95711912_flairs
kaffirs17325552kaff_irs
zaffars22325232zaffa_rs
zaffirs22375662zaff_irs
afar76720783a_fa_r_
afeard1058263afea_rd
affable15117403affable
affably1855183affably
affects1535393affects
affiant1348433affiant
affiants1445233affiants
affine12310503aff_ine
affines1339483affines
affix1836003aff_i_x
affixers2143293affixers
affixes2035503affixes
afflatus1442683afflatus
afflict1547043afflict
afflicts1644003afflicts
afford1346493aff_ord
affords1435023affords
affrayers1842213affrayers
affrays1644063affrays
afire86215913a_f_ire
afraid1049723afrai_d
afrits9311903a_frits
afters94717073a_fters
agars66120643a_ga_rs
agnails837003agnails
airs46447423___airs
alcaics1137023alcaics
alfakis1475073alfakis
alfas87219043alfa__s
altars64518153alta_rs
ambaris113112163ambaris
amirs75924923a__mirs
anears63717183anea_rs
antiars7314623antiars
ascaris93613323ascaris
assails769093assails
assais6711963assai_s
attains7310983attains
attars64515313atta_rs
avails939693a_vails
awaits96411953a_waits
baffies153612943baff_ies
bafflers16356593bafflers
caffeins1645123caffeins
chairs114916183_chairs
deairs74013783_deairs
eclairs935963eclairs
effacers16244233effacers
effaces15277273effaces
fails85631483__fails
fair76332523__fair_
fairy115318283__fairy
fakirs13468083_fakirs
faqirs18456033_faqirs
faquirs1943863faquirs
fears84829393_fea_rs
fiars86720833_fia_rs
firs76637713__f_irs
flails94313003_flails
flair86114123_flair_
flirs85518933__flirs
frails93716473_frails
friars93812093_friars
funfairs1442133funfairs
gaffers14428713gaff_ers
glairs75211333_glairs
haffits1636193haff_its
hairs86225173__hairs
impairs1135823impairs
kaffir16345303kaff_ir_
kafirs13306983kaf_irs
kefirs13396653kef_irs
lairs55425873__lairs
maffias15327283maff_ias
maftirs1236043maftirs
mairs76228303__mairs
midairs1037203midairs
mohairs1234953mohairs
offals1235893offa_ls
offers12349963off_ers
pairs75325833__pairs
parfaits1346913parfaits
raffias13237713raff_ias
rafflers14317363rafflers
repairs9319973repairs
safaris101110663safaris
sofars94712783sofa_rs
stairs65416333_stairs
suffaris1445083suffaris
taffias13377413taff_ias
taffies133012693taff_ies
taffrails1542063taffrails
unfair936233unfair_
unhairs1036373unhairs
vairs85019133__vairs
waffies163611443waff_ies
wafflers17306323wafflers
wairs86424063__wairs
zaffar21385043zaffa_r_
zaffers22386773zaff_ers
zaffir21395513zaff_ir_

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.1531167915.0
2DLD Change Limit1340271136.78319759.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.98225593.1
 
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.