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

123 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
reindeer93629(None) 
reindeers1044871reindeers
reindex1536092reind_ex
reindexed1843882reindexed
reindexes1744292reindexes
reinter73116842rein_ter
reminder113110512remind_er
render74024142re_nd_er
renderer9239742re_nderer
rewinder12317662rewind_er
bendee94121023be_ndee_
bendees103913863be_ndees
bender95223303be_nd_er
bendier103111413be_ndier
binder94422873_bind_er
blinder103912983blind_er
cinder94119123_cind_er
eider64624743_ei_d_er
endear74110013_e_ndear
ender64325863_e_nd_er
fender103718723fe_nd_er
finder104020233_find_er
flinder11319873flind_er
gender83517933ge_nd_er
grinder93312393grind_er
hinder104120063_hind_er
hinderer1238273_hinderer
indeed83913563__indeed
indexer15287253__indexer
joinder15337593joind_er
kinder113716843_kind_er
kindler12309983_kindler
lender73921273le_nd_er
meander1049973meand_er
meanderer1244733meanderer
mender93520793me_nd_er
minder94822503_mind_er
orienteer943213orienteer
pinder94523453_pind_er
raider74318743rai_d_er
rainier71614263rain_ier
rainwear1143093rainwear
randier83618473r_andier
reader73628293re_ad_er
readier83117423re_adier
redder83918143re__dder
redear73515173re__dear
redeem9311533re__deem
reedier83815303re_edier
reenter73217793reen_ter
refiner105316913refin__er
refunder1236503refund_er
reifier103414523rei_fier
reincur945133rein_cur
reindict1187533reindict
reinduce1165423reinduce
reinduced1374593reinduced
reinduces1285453reinduces
reinduct1176153reinduct
reined74425523rein__ed
reinfect1346483reinfect
reinject1745543reinject
reinjure1544983reinjure
reinked1239793rein_ked
reinless8139433reinless
reinsert8313223reinsert
reinsmen1047073reinsmen
reinsure837913reinsure
reinsurer945603reinsurer
reinters82614773reinters
reinvent1138903reinvent
reinvest1138203reinvest
reissuer854523reissuer
reiver95318293rei__ver
rejoinder1743713rejoind_er
rekindle1344643rekindle_
rekindled1543313rekindled
rekindles1443863rekindles
remainder1244683remaind_er
reminded123411523remind_ed
reminders12308653reminders
remodeler1243923remodeler
rended84524103re_nd_ed
rendered102512263re_ndered
renderers10208093re_nderers
renders83821673re_nders
reneger8299493re_neger
renewer10248693re_newer
renter64527413re_n_ter
rentier73618223re_ntier
reorder8239483reord_er
repiner94816903repin__er
rescinder1245293rescind_er
resider84615803resid_er
reuniter838323reuniter
rewinded13277673rewind_ed
rewinders13246503rewinders
ridder84015143r_i_dder
riddler93411263r_iddler
rider65231303r_i_d_er
rinded84418983r_ind_ed
ringer74526063r_in_ger
rinser64317213r_in_ser
rounder83514603round_er
ruiner64013643ruin__er
seiner64622483sein__er
sender73824413se_nd_er
spindler11297983spindler
swindler12257723swindler
tender74121843te_nd_er
tenderer9228733te_nderer
tinder73821803_tind_er
trendier937913tre_ndier
veiner94514753vein__er
veinier10269583vein_ier
vendee105617263ve_ndee_
vendees114011453ve_ndees
vender103418423ve_nd_er
veneer94511693ve_n_eer
weiner94214133wein__er
weirder1144923weird_er
winder104025263_wind_er
windier113412163_windier

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621237.98618302.3
3Display Results1231230.0432860.5
 (SQL Overall)1786911238.43521184.5
 
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.