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

81 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
affaire134446(None) 
affair1234351affair_
affaires1444301affaires
affairs1334161affairs
affable15117402affable
affine12310502aff_ine
affirm1435522aff_irm
afire86215912a_f_ire
acquire1835603acquire
admire949933a_dmire
afar76720783a_fa_r_
afars85716513a_fa_rs
afeard1058263afea_rd
afeared1176833afea_red
affably1855183affably
affiance1645653affiance
affiant1348433affiant
affiche1844313affiche
affined1436413aff_ined
affines1339483aff_ines
affirmed1743213aff_irmed
affirmer1643083aff_irmer
affirms1534383aff_irms
affix1836003aff_i_x
affixed2134123aff_ixed
affixer2033913aff_ixer
affixes2035503aff_ixes
afflict1547043afflict
afford1346493aff_ord
affrayer1742693affrayer
aflame1138723afla_me
afore85818603a_f_ore
afraid1049723afrai_d
aglare7312433agla_re
airfare1047243airfa_re
alcaide1088453alcaide
armoire938133armoire
aspire8612123a_spire
attire62412383a_ttire
avodire1143763avodire
aware86420023a_wa_re
caffeine1644513caffeine
carfare12310073carfa_re
daffier1457833daff_ier
effable15106673effable
efface14366673effa_ce
effacer15255413effacer
fair76332523__fair_
faired105915773__faired
fairer95212063__fairer
fairs85825443__fairs
fairy115318283__fairy
fanfare1336673fanfa_re
fare76354463__fa_re
fiacre1137623_fiacre
fire76245593__f_ire
flair86114123_flair_
flairs95711913_flairs
flare84823633_fla_re
fraise94214913_fraise
glaire74411303_glaire
iffier1236763iff_ier
infare9313083infa_re
kaffir16345303kaff_ir_
kaffirs17325553kaff_irs
office1435693off_ice
offline1345783offline
offside1453693offside
refire95419473ref_ire
taffarel1442563taffa_rel
unfair936233unfair_
unfairer11184283unfairer
waffie15338563waff_i_e
wafflier1733953wafflier
warfare1336733warfa_re
zaffar21385043zaffa_r_
zaffars22325233zaffa_rs
zaffir21395513zaff_ir_
zaffirs22375663zaff_irs
zaffre21354663zaff__re
zaire14311993__zaire

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.436409841.7
2DLD Change Limit134027816.29621287.6
3Display Results81810.0332454.5
 (SQL Overall)178691816.76526414.0
 
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.