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

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
deairs7401378(None) 
deair65817191deair_
dears65736881dea_rs
airs46447422__airs
bears75739042bea_rs
chairs114916182chairs
dairy97016302d_airy
dais57040702d_ai_s
deads75726912dea_ds
deaired9411532deaired
dealers84118612dealers
deals65435342dea_ls
deans66131392dea_ns
dear55343602dea_r_
dearie73319812dearie
dearies83526272dearies
deary95826842dea_ry
deaths105914442deaths
deaves105319532deaves
debars94218042debars
debits94214502debits
debris93311492debris
decors94017772decors
deers64930522de_ers
defers105116942defers
defiers113913992defiers
defies104624052defies
defis96717502defi_s
deils65722862de_ils
delis64928542deli_s
demies94825802demies
demits94918072demits
demurs939772demurs
denars74621432denars
deniers84515182deniers
denies74729642denies
denims95214322denims
derails84216392derails
derris73615272derris
desire7415302desire
desires81316132desires
despairs1144942despairs
details84214042details
detains83716092detains
deters74724682deters
devils104412812devils
devoirs1175782devoirs
dewars105117072dewars
dexies145018342dexies
diapirs10347642diapirs
drails74716952drails
drains73719402drains
drears74614252drea_rs
ears46356592_ea_rs
emirs76116162_emirs
fairs85825442_fairs
fears84829392fea_rs
flairs95711912flairs
gears64628692gea_rs
glairs75211332glairs
hairs86225172_hairs
hears86737372hea_rs
heirs85618562he_irs
kefirs13396652kefirs
keirs95313672ke_irs
lairs55425872_lairs
lears55938732lea_rs
mairs76228302_mairs
nears55529422nea_rs
pairs75325832_pairs
pears75138612pea_rs
rears54739652rea_rs
repairs9319972repairs
sears54744912sea_rs
stairs65416332stairs
tears55436462tea_rs
vairs85019132_vairs
wairs86424062_wairs
wears86030302wea_rs
weirs84316492we_irs
years84527672yea_rs

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 Filter178691825510.330541487.9
2DLD Change Limit82551812.18637763.5
3Display Results81810.0302700.0
 (SQL Overall)178691812.54670185.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.