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

170 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
biller8492348(None) 
baller83825201baller
bilker124913441bilker
billed94224901billed
billers94720831billers
billet86029721billet
birler85715081birler
filler94623621filler
giller74519731giller
hiller94421631hiller
iller54821291_iller
killer104917951killer
miller84625411miller
siller64026061siller
tiller64222541tiller
willer94021061willer
bailer85425252bailer
balder95318862balder
baler75635282b_aler
balker124519162balker
balled94926892balled
ballers94421012ballers
ballet84733972ballet
bawler114315052bawler
belier84423562belier
belle75827832belle_
belled94626192belled
belles85325992belles
belter84720962belter
bibber94613572bibber
bible95119422bible_
bibles104617642bibles
bicker144819172bicker
bidder104114862bidder
bider85728382bi_der
bier65531842bi__er
biflex1834952biflex
bigger104315062bigger
biker116022562bi_ker
bilayer12347802bilayer
bile66147192bi_le_
biles75542142bi_les
bilge87618912bilge_
bilged105513182bilged
bilges94915632bilges
bilgier10358532bilgier
bilked134012942bilked
bilkers134711862bilkers
bill67239952bill__
billeter1037562billeter
billets94516152billets
billie85019172billie
billies93923502billies
billon83713832billon
billow114111222billow
bills75632862bill_s
billy105525362bill_y
binder94422872binder
biner75930692bi_ner
binger94923452binger
birder94915492birder
birle75023632birle_
birled94416992birled
birlers93813002birlers
birles84920642birles
bister84922762bister
biter75030032bi_ter
bitter84622672bitter
bluer74918492b_luer
boiler84319272boiler
bolder94820932bolder
bolled94722652bolled
bolter83920752bolter
bowler114217312bowler
brailler1036882brailler
bridler103811072bridler
bugler94717722bugler
builder1037572builder
bulger94917352bulger
bulled94626492bulled
bullet84528612bullet
bullier94116432bullier
burler84723832burler
butler84220032butler
caller85125482caller
chiller124112182chiller
culler84322252culler
dialer74315432dialer
dialler848812dialler
dilled84122222dilled
driller84311882driller
duller74017702duller
eviller1056672eviller
faller94621232faller
feller94419552feller
filer85433002fi_ler
fille84327402fille_
filled104922262filled
fillers104320212fillers
filles94224522filles
fillet95027082fillet
filmer114112402filmer
filter94517632filter
friller104111742friller
fuller94220382fuller
gilder84415532gilder
gilled84521632gilled
gillers84216902gillers
griller84513352griller
heller93322512heller
hilled104022222hilled
hillers103718732hillers
hillier103413962hillier
holler93520612holler
huller93919102huller
idler65015662_idler
jilter133512512jilter
killed113918772killed
killers114215582killers
kilter103714342kilter
loller63315282loller
luller63415482luller
milder93818452milder
miler75733062mi_ler
milker124814322milker
mille75029132mille_
milled94326172milled
millers93621342millers
milles84526562milles
millet84030742millet
millier93716702millier
milter84921232milter
muller83820352muller
nilled73919452nilled
oiler54628282oi_ler
oilier64417232oilier
pilfer1139162pilfer
pillar8314022pillar
pilled94222752pilled
poller83921852poller
puller83820812puller
rifler94014262rifler
rille55728732rille_
rilled74525652rilled
rilles64725502rilles
rillet64828852rillet
roller63919792roller
seller63824602seller
sidler74716962sidler
sillers73822102sillers
sillier74017592sillier
silver93815812silver
spiller92914332spiller
stiller73414302stiller
swiller103211662swiller
taller63721962taller
teller63519832teller
tiler56131022ti_ler
tilled74722952tilled
tillers73418742tillers
tilter63417692tilter
toller63819442toller
triller74215892triller
viler86324162vi_ler
wilder103616472wilder
wilier93217072wilier
willed104722452willed
willers103517912willers
willet95124832willet
yeller94214512yeller

Search took 7 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 Filter178691825511.033172982.6
2DLD Change Limit825511704.92016778.7
3Display Results1701700.0931828.0
 (SQL Overall)1786911706.04629555.2
 
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.