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

129 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
bilker12491344(None) 
balker124519161balker
bicker144819171bicker
biker116022561bi_ker
bilked134012941bilked
bilkers134711861bilkers
biller84923481biller
milker124814321milker
backer144525522backer
bailer85425252bail_er
baker115629542b_aker
balder95318862balder
baler75635272bal_er
balked135219412balked
balkers134915722balkers
balkier134111982balkier
baller83825202baller
banker124222732banker
barker124822862barker
beaker125520692beaker
belier84423562belier
belter84720962belter
bibber94613572bibber
bickers154316552bickers
bidder104114862bidder
bider85728372bi_der
bier65531832bi__er
bigger104315062bigger
bike106532602bi_ke_
biked125320032bi_ked
bikers124517552bi_kers
bikes117529472bi_kes
bilayer12347802bilayer
bile66147182bil_e_
biles75542142bil_es
bilge87618912bilge_
bilged105513182bilged
bilges94915632bilges
bilgier10358532bilgier
bilk105824422bilk__
bilks115117892bilk_s
billed94224902billed
billers94720832billers
billet86029722billet
binder94422872binder
biner75930692bi_ner
binger94923452binger
birder94915492birder
birler85715082birler
bister84922762bister
biter75030032bi_ter
bitter84622672bitter
blinker134110212blinker
bluer74918492b_luer
boiler84319272boil_er
bolder94820932bolder
bolter83920752bolter
booker124719192booker
bosker123813652bosker
brisker134210292brisker
broker124314242broker
bucker145420462bucker
builder1037572builder
bulger94917352bulger
bulked134216742bulked
bulkier134111512bulkier
bunker124519372bunker
burker125221172burker
busker125517832busker
calker124917082calker
dicker134521402dicker
diker105524552di_ker
filer85433002fil_er
filler94623622filler
filmer114112402filmer
filter94517632filter
gilder84415532gilder
giller74519732giller
hiker125119392hi_ker
hiller94421632hiller
icker114018442_icker
iller54821292_iller
inker94421092_inker
jilter133512512jilter
jinker174013542jinker
kicker114116182kicker
killer104917952killer
kilter103714342kilter
licker125222042licker
liker95627062li_ker
linker104321472linker
milder93818452milder
miler75733062mil_er
milked134612572milked
milkers134411612milkers
milkier133411162milkier
miller84625412miller
milter84921232milter
mirker123712692mirker
nicker123818702nicker
oiler54628282oil_er
oilier64417232oilier
picker144422172picker
piker115622842pi_ker
pilfer1139162pilfer
pinker125322442pinker
risker105414492risker
sicker124023902sicker
siker95326032si_ker
silked114314812silked
silken104410852silken
silkier114411642silkier
siller64026062siller
silver93815812silver
sinker103620902sinker
sulker104015922sulker
talker103916222talker
ticker124321502ticker
tiler56131022til_er
tiller64222542tiller
tilter63417692tilter
tinker103619922tinker
viler86324162vil_er
walker133913992walker
wicker154518672wicker
wilder103616472wilder
wilier93217072wilier
willer94021062willer
winker134220292winker

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.343520965.0
2DLD Change Limit825511292.25036689.3
3Display Results1291290.0333909.1
 (SQL Overall)1786911292.62668046.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.