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

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
ridder8401514(None) 
bidder104114861bidder
gridder10367761gridder
kidder123811111kidder
redder83918141redder
ridded93615121ridded
ridden83511721ridden
ridders93612491ridders
riddler93411261riddler
rider65231311ri_der
rudder83812801rudder
widder112913971widder
adder75419592_adder
aider65431142ai_der
arider74717742ari_der
badder103817512badder
bedder104215792bedder
bidden104010792bidden
bidders114012312bidders
bider85728382bi_der
binder94422872binder
birder94915492birder
bridler103811072bridler
budder104314812budder
cider84723322ci_der
cinder94119122cinder
codder104416342codder
diddler103511512diddler
dodder94712912dodder
eider64624752ei_der
fiddler12309952fiddler
finder104020232finder
fodder114712112fodder
gadder93714712gadder
giddier10308722giddier
gilder84415532gilder
girder84312062girder
gridded11387582gridded
gridders11286292gridders
grinder93312392grinder
hidden11429742hidden
hider95024092hi_der
hinder104120062hinder
idler65015662_idler
judder15439422judder
kidded13299402kidded
kidders13399172kidders
kinder113716852kinder
ladder84617622ladder
lidded93410242lidded
lieder74912322lieder
madder103515592madder
midden104112852midden
middler112712272middler
milder93818452milder
minder94822502minder
mudder104413492mudder
nodder84811942nodder
odder74515392_odder
padder103415492padder
piddler112911522piddler
pinder94523462pinder
prodder1147952prodder
radded94716492radded
raider74318742raider
reader73628292reader
redded94019552redded
redden83613622redden
redders93615342redders
render74024142render
ribber103515492ribber
ribier84414232ribier
ricer74726612ri_cer
richer114015042richer
riddle83915712riddle
riddled103012042riddled
riddlers10269102riddlers
riddles93215022riddles
ride55945142ri_de_
riders74123902ri_ders
rides66140822ri_des
ridge75018682ridge_
ridged94014222ridged
ridgel8399972ridgel
ridges85817012ridges
ridgier937882ridgier
ridley10169542ridley
riever94811652riever
rifer84721982ri_fer
rifler94014262rifler
rigger85616712rigger
rimer75429242ri_mer
rimier83916272rimier
rimmer103516032rimmer
rinded84418982rinded
ringer74526062ringer
rinser64317212rinser
rioter64817282rioter
riper74328402ri_per
ripper103518652ripper
riser55431052ri_ser
risker105414492risker
ritter63822422ritter
river85731692ri_ver
rodded93713702rodded
rudders93210652rudders
ruddier9338522ruddier
ruder65320542r_uder
sadder82916972sadder
siddur834572siddur
sidler74716962sidler
skidder1365732skidder
tedder83312162tedder
tiddler93110002tiddler
tidier73515112tidier
tinder73821802tinder
udder76314282_udder
wadder114215482wadder
wedder113612302wedder
widders123512272widders
wider94826362wi_der
wilder103616472wilder
winder104025262winder

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.360496363.9
2DLD Change Limit825511232.39034540.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911232.79663909.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.