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

90 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
kidder12381109(None) 
bidder104114861bidder
kidded13299381kidded
kidders13399161kidders
kinder113716841kinder
ridder84015141ridder
skidder1365731skidder
widder112913971widder
adder75419592_adder
aider65431132ai_der
badder103817512badder
bedder104215782bedder
bidden104010792bidden
bidders114012302bidders
bider85728372bi_der
binder94422872binder
birder94915492birder
budder104314812budder
cider84723312ci_der
cinder94119122cinder
codder104416332codder
diddler103511512diddler
dodder94712912dodder
eider64624742ei_der
fiddler12309952fiddler
finder104020232finder
fodder114712112fodder
gadder93714712gadder
giddier10308722giddier
gilder84415532gilder
girder84312062girder
gridder10367762gridder
hidden11429742hidden
hider95024082hi_der
hinder104120062hinder
idler65015662_idler
judder15439422judder
kicker114116182kicker
kiddie12359392kiddie
kiddies133412282kiddies
kiddo11398942kidd_o
kiddoes13387062kiddoes
kiddos12416862kiddos
kiddy144910272kidd_y
kidney1434752kidney
kier86526802ki__er
killer104917952killer
kilter103714342kilter
kindler12309982kindler
kipper143414202kipper
kisser104212452kisser
kiter95523212ki_ter
ladder84617622ladder
lidded93410242lidded
lieder74912322lieder
madder103515592madder
midden104112852midden
middler112712272middler
milder93818452milder
minder94822502minder
mudder104413492mudder
nodder84811942nodder
odder74515392_odder
padder103415492padder
piddler112911522piddler
pinder94523452pinder
redder83918132redder
ridded93615122ridded
ridden83511722ridden
ridders93612482ridders
riddler93411262riddler
rider65231302ri_der
rudder83812802rudder
sadder82916972sadder
siddur834572siddur
sidler74716962sidler
skidded1465082skidded
skidders1454812skidders
skiddier1464192skiddier
tedder83312152tedder
tiddler93110002tiddler
tidier73515112tidier
tinder73821802tinder
udder76314282_udder
wadder114215482wadder
wedder113612292wedder
widders123512262widders
wider94826352wi_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.1101624463.6
2DLD Change Limit82551902.47033421.5
3Display Results90900.0303000.0
 (SQL Overall)178691902.61068464.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.