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

115 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
bidder10411486(None) 
badder103817511badder
bedder104215791bedder
bidden104010791bidden
bidders114012311bidders
bider85728381bi_der
binder94422871binder
birder94915491birder
budder104314811budder
kidder123811111kidder
ridder84015141ridder
widder112913971widder
abider95314462abi_der
adder75419592_adder
aider65431142ai_der
badger105415082badger
balder95318862balder
bander93928222bander
beader94623792beader
bedded115114072bedded
bedders113513382bedders
bender95223302bender
bibber94613572bibber
bicker144819172bicker
biddies113514492biddies
biddy124612702bidd_y
bide76041512bi_de_
bided95424972bi_ded
biders94822802bi_ders
bides85536782bi_des
bidet84935632bi_det
bier65531842bi__er
bigger104315062bigger
biker116022562bi_ker
bilker124913442bilker
biller84923482biller
binders103920742binders
bindery13459832bindery
biner75930692bi_ner
binger94923452binger
birded104414302birded
birders103913262birders
birler85715082birler
bister84922762bister
biter75030032bi_ter
bitter84622672bitter
bladder11429152bladder
blader93618582blader
blinder103912992blinder
bolder94820932bolder
bonder95324782bonder
border94419972border
bridler103811072bridler
budded113912332budded
budders113812102budders
budger104617712budger
builder1037572builder
cider84723322ci_der
cinder94119122cinder
codder104416342codder
diddler103511512diddler
dodder94712912dodder
eider64624752ei_der
fiddler12309952fiddler
finder104020232finder
fodder114712112fodder
gadder93714712gadder
giddier10308722giddier
gilder84415532gilder
girder84312062girder
gridder10367762gridder
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
redder83918142redder
ridded93615122ridded
ridden83511722ridden
ridders93612492ridders
riddler93411262riddler
rider65231312ri_der
rudder83812802rudder
sadder82916972sadder
siddur834572siddur
sidler74716962sidler
skidder1365732skidder
tedder83312162tedder
tiddler93110002tiddler
tidier73515112tidier
tinder73821802tinder
udder76314282_udder
wadder114215482wadder
wedder113612302wedder
widders123512272widders
wider94826362wi_der
wilder103616472wilder
winder104025262winder

Search took 8 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.986181228.2
2DLD Change Limit825511155.96613836.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.99825534.6
 
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.