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

122 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
widder11291397(None) 
bidder104114861bidder
kidder123811101kidder
ridder84015141ridder
wadder114215481wadder
wedder113612301wedder
widders123512271widders
wider94826351wi_der
wilder103616471wilder
winder104025261winder
adder75419592_adder
aider65431132ai_der
badder103817512badder
bedder104215792bedder
bidden104010792bidden
bidders114012312bidders
bider85728372bi_der
binder94422872binder
birder94915492birder
budder104314812budder
cider84723312ci_der
cinder94119122cinder
codder104416342codder
diddler103511512diddler
dodder94712912dodder
eider64624742ei_der
fiddler12309952fiddler
finder104020232finder
fodder114712112fodder
gadder93714712gadder
giddier10308722giddier
gilder84415532gilder
girder84312062girder
gridder10367762gridder
hidden11429742hidden
hider95024082hi_der
hinder104120062hinder
idler65015662_idler
judder15439422judder
kidded13299392kidded
kidders13399172kidders
kinder113716842kinder
ladder84617622ladder
lidded93410242lidded
lieder74912322lieder
madder103515592madder
midden104112852midden
middler112712272middler
milder93818452milder
minder94822502minder
mudder104413492mudder
nodder84811942nodder
odder74515392_odder
padder103415492padder
piddler112911522piddler
pinder94523452pinder
redder83918142redder
ridded93615122ridded
ridden83511722ridden
ridders93612492ridders
riddler93411262riddler
rider65231302ri_der
rudder83812802rudder
sadder82916972sadder
siddur834572siddur
sidler74716962sidler
skidder1365732skidder
swidden1234232swidden
tedder83312162tedder
tiddler93110002tiddler
tidier73515112tidier
tinder73821802tinder
twiddler13244872twiddler
udder76314282_udder
wadded124014172wadded
wadders123812442wadders
waddler124010792waddler
wader95325362w_ader
wander104423712wander
warder104020272warder
wedded123811842wedded
wedders123610722wedders
weeder103315512weeder
weirder1144922weirder
welder102914412welder
whidded1634422whidded
wicker154518672wicker
widdie113410732widdie
widdies123514032widdies
widdle113814842widdle
widdled133511232widdled
widdles123514342widdles
widdy136112182widd_y
wide85235412wi_de_
widen94717972wi_den
widener11318692widener
wides94832822wi_des
widget113815262widget
widower1435342widower
wielder11197672wielder
wiener94513542wiener
wilded113714502wilded
wilders113513502wilders
wilier93217072wilier
willer94021062willer
wincer115018192wincer
winded114918212winded
winders113721262winders
windier113412162windier
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winter94222802winter
wiper105421292wi_per
wirer85124952wi_rer
wirier94215552wirier
wiser85522802wi_ser
wisher123617062wisher
wither124321352wither
wiver115924512wi_ver
wonder103617812wonder

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 Limit825511222.37334787.6
3Display Results1221220.0333697.0
 (SQL Overall)1786911222.73665311.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.