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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
madre8572017(None) 
cadre85419021cadre
made75440241mad_e
madres93718181madres
mare64759331ma_re
padre86018161padre
acre67330772_acre
adore65723672_adore
adze1412820572_adze
are37874572_a_re
bade75140882bad_e
badge94819692badge
barde85330772barde
bare65460522ba_re
barre75929542barre
cade76443912cad_e
cadge94018792cadge
cadres94017932cadres
care66968372ca_re
dare55848862da_re
eagre64315322eagre
fade85736342fad_e
fader94421512fader
fadge104817002fadge
fare76354462fa_re
gadje1457742gadje
hade85440192had_e
hare76255732ha_re
jade125325442jad_e
lade56345982lad_e
lader65633722lader
ladle66320442ladle
maar66025062maar_
maars74621632maars
mabe85733362ma_be
mace87345792ma_ce
macer912126942macer
mache125925302mache
macle96127002macle
macro94718172macro
mad68958712mad__
madam10316222madam
madame1139852madame
madded113513552madded
madden103912522madden
madder103515592madder
madly115218132madly
madmen113511742madmen
madras94316432madras
madrone102812662madrone
mads76845372mad_s
maduro936982maduro
mae57659112ma__e
mage75739132ma_ge
mahoe10315572mahoe
maigre9309162maigre
maile75232222maile
mair66133782mair_
mairs76228302mairs
maize164618562maize
make105537892ma_ke
maker114127812maker
male66052302ma_le
malgre9299302malgre
mamie95826002mamie
mandrel1038682mandrel
mane65052032ma_ne
mange84930192mange
manse75528232manse
manure8313652manure
maple95521142maple
mar57965952ma_r_
mara67444572ma_ra
marc87034632ma_rc
mares76457632ma_res
marge85328332marge
mark105138062ma_rk
marl66341622ma_rl
marred95421042marred
marrer83716672marrer
marry104821692marry
mars66261872ma_rs
marse76231152marse
mart66865982ma_rt
maser75029972maser
masse75125292masse
mate65154222ma_te
mater74438862mater
matres84522232matres
matte75626842matte
mature8313462mature
maugre9308972maugre
mauve104013272mauve
mavie104722562mavie
maybe12311132maybe
maze155434982ma_ze
mazer165722422mazer
meagre9349322meagre
merde84320122merde
mere67244442m_ere
metre74821302metre
midge95016552midge
mire66748232m_ire
mitre75522422mitre
mode75840302mod_e
moire71017322moire
more67154522m_ore
mudra83912432mudra
mure65941332m_ure
murre74821072murre
nacre75715362nacre
padle84522342padle
padres95016982padres
padri85815172padri
pare66760842pa_re
rare45348432ra_re
sabre74821502sabre
sade55544472sad_e
sadhe94815132sadhe
tare45957622ta_re
tarre55825632tarre
wade85237062wad_e
wader95325362wader
ware76254722wa_re
yare75636942ya_re
zaire14311992zaire

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 Filter178691538000.326548131.9
2DLD Change Limit538001261.75030742.9
3Display Results1261260.0333818.2
 (SQL Overall)1786911262.10984727.8
 
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.