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 “dollars” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

369 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
dollars8331102(None) 
collars93816571collars
dollar74110981dollar_
bollard103210502bollard
bollards11339152bollards
cellars93713692cellars
collar83816172collar_
collard103712922collard
collards113310192collards
doblas93812292dobla_s
dogears937512dogears
dollies83620982dollies
dollops10287962dollops
dolls66126922doll__s
dolmans10479682dolmans
dolmas95213042dolma_s
dolors75115312do_lors
dolours8438822dolours
doulas75114992doula_s
dullard936602dullard
dullards1045492dullards
hollas94616902holla_s
hollers103818232hollers
lollers72713792lollers
molars85517322mo_lars
mollahs12328282mollahs
ollas54218282_olla_s
pillars9313492pillars
polars84419352po_lars
pollard103511142pollard
pollards11299522pollards
pollers93420022pollers
poplars113910332poplars
rollers73117472rollers
tolars64817942to_lars
tollbars1045442tollbars
tollers73217462tollers
allays94313743_allays
altars64518153_altars
ashlars10297063ashlars
axillars15235993axillars
ballads104212913ballads
ballers94421013ballers
billers94720833billers
blears85116453_blears
boars75229603bo__ars
boilers93417063boilers
bolar75123473bo_lar_
bolas74733763bo_la_s
bolivars1344973bolivars
bolls75531313boll__s
bolters94017803bolters
bowlers123715783bowlers
boxcars1834773boxcars
boyars115611983bo_yars
boylas113011723boyla_s
calcars11312653calcars
callans94518473callans
callas84526753calla_s
callers94221963callers
cellar84514983cellar_
chollas123811353cholla_s
clears84116563_clears
coalas87418963coala_s
coalers94419353coalers
coilers93619903coilers
colas75436773co_la_s
coleads102911423coleads
collage102813763collage
collages113514243collages
collapse1244273collapse
collared113211143collared
collaret103116703collaret
collarets11327333collarets
collate92919683collate
collates103019143collates
collators11410343collators
collets93517903collets
colliers103613583colliers
collies94326583collies
collins93419833collins
collops112611753collops
colors86622373co_lors
colours95913443colours
colters93522443colters
colzas174010513colza_s
coolers93522493coolers
costars94218013costars
cottars94412243cottars
cougars1038443cougars
cullays12347703cullays
cullers93418853cullers
dalles74222063dall_es
dalliers93610613dalliers
dallies84023193dallies
damars93815003d_amars
dammars12308193dammars
darbars10510093darbars
dealers84118613dealers
dears65736883d__ears
debars94218043d_ebars
declare10411223declare
declares11611313declares
declass1038733declass
declaws1336253declaws
delays104014053d_elays
deleads9379703deleads
dellies83622213dellies
dells66630943dell__s
deltas74414823delta_s
delvers113411993delvers
denars74621433d_enars
deodars937623deodars
dewars105117073d_ewars
dewlaps1334663dewlaps
dialers83614303dialers
diallers957773diallers
dillies84122163dillies
dills65530973dill__s
dinars75417563d_inars
disbars10310323disbars
doats65224883do__ats
dobbers123513253dobbers
dobla84913643dobla__
doblons1037043doblons
dobras94811913dobra_s
dockers143715003dockers
doctors1039993doctors
dodders105511793dodders
dodgers105213823dodgers
doers65225713do__ers
doffers14359853doffers
dogcart1148043dogcart
dogcarts1243883dogcarts
dogear838193dogear_
doggers104413433doggers
doglegs1034783doglegs
dogmas105011243dogma_s
dognaps1134393dognaps
doilies84017363doilies
doles67843753do_l_es
doll56632493doll___
dollarize1946193dollarize
dollarizes2046043dollarizes
dolled83518073doll_ed
dollied93811143dollied
dolling93817373dolling
dollish11610093dollish
dollop9259363doll_op
dolly96125203doll__y
dolma86214173dolma__
dolmades1245463dolmades
dolman95312403dolma_n
dolmens10388693dolmens
dolor67617963do_lor_
dolour75710133dolour_
dols56943053do_l__s
dolts65626313do_l_ts
donas65926473do_na_s
dongas84914613donga_s
donnas75511323donna_s
donors75115793do_nors
doodads1035093doodads
doodlers10338843doodlers
doolees83711613doolees
doolies83920713doolies
doors65022133do__ors
doozers17419293doozers
dopas85019063do_pa_s
dopers95522483do_pers
dormers104313923dormers
dorpers104113173dorpers
dorrs65520593do__rrs
dors56747603do___rs
dorsals84110843dorsals
dorsers83516303dorsers
dosers75723633do_sers
dossals8379293dossals
dossers84516233dossers
dotard839053do_tard
dotards937253do_tards
doters74423913do_ters
dotters83715973dotters
doublers11288503doublers
doula65717773doula__
doumas95314813douma_s
dourahs11487253dourahs
douras75016723doura_s
dousers84817273dousers
dowers104523293do_wers
downers113912773downers
dowsers115013533dowsers
doyleys14384923doyleys
doylies114512573doylies
dozers164815423do_zers
drears74614253d_rears
drillers9429723drillers
droller84110283droller_
drollery12314793drollery
drolls75312393droll__s
duelers83412053duelers
duellers9268223duellers
dulias71212743dulia_s
duller74017703duller_
dulls64523743dull__s
durbars1077973durbars
dwellers12356083dwellers
fallals103310193fallals
fallers103917993fallers
fellahs13428393fellahs
fellas95116963fella_s
fellers104117543fellers
fillers104320213fillers
folders113514393folders
foliar93210973foliar_
folles93820473foll_es
follies103618943follies
follis93113903foll_is
follows13409923follows
foulard11257283foulard
foulards12266463foulards
fowlers133411203fowlers
fullams1236553fullams
fullers103817373fullers
fulmars1246423fulmars
gillers84216903gillers
goldarn944383goldarn
goldarns1043593goldarns
golfers114410083golfers
goliard936073goliard
goliards1045133goliards
hallahs133912463hallahs
hellers103619833hellers
hillers103718733hillers
hoars85925553ho__ars
holard10410573ho_lard
holards1148433ho_lards
holders113715903holders
holla84918493holla__
hollaed11359853hollaed
holland11349473holland
hollands12247273hollands
holler93520613holler_
hollies103420813hollies
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633holl_os
hollows134412333hollows
howlers133312353howlers
hullers103616263hullers
jolliers15357433jolliers
jollies143516273jollies
jolters143711993jolters
jowars16369653jo_wars
killers114215583killers
knollers12255143knollers
koalas104011663koala_s
kolas94822233ko_la_s
lallans74113533lallans
lars46956573___lars
lears55938733__lears
liars54723163__liars
loller63315283loller_
lollies73116923lollies
lollops9227443lollops
lolls512121733loll__s
lullers73213353lullers
malars85020683_malars
mallard10310273mallard
mallards1138323mallards
medlars10259443medlars
millers93621343millers
modulars1165833modulars
moilers93615203moilers
molar75223093mo_lar_
molas75132093mo_la_s
molders103315553molders
mollah11319453molla_h
mollies93420233mollies
molls75129783moll__s
molters93816973molters
moolahs12347383moolahs
moolas83615593moola_s
mortars93411523mortars
mullahs12388733mullahs
mullas84215933mulla_s
mullers93217303mullers
mylars114310443_mylars
nonwars10109003nonwars
nullahs10316993nullahs
oars46846033_o__ars
oculars948363oculars
oglers74313183_oglers
oilers64721193_oilers
olla44821173_olla__
onlays9398713_onlays
ottars64112223_ottars
pallors9314363pallors
pedlars103210213pedlars
pillar8314023pillar_
polar75623453po_lar_
polders103617373polders
polers84225643po_lers
polkas1239103polka_s
pollack1567333pollack
pollacks1656373pollacks
pollees93215333pollees
pollens93713303pollens
poller83921853poller_
polls74627723poll__s
poolers94217423poolers
poplar103611113poplar_
poulard10299733poulard
poulards11288233poulards
pullers93618483pullers
pulsars9358913pulsars
roars55622243ro__ars
rolfers104011813rolfers
roller63919793roller_
rolls55326233roll__s
rollways1444233rollways
scalars93711903scalars
sellers73721323sellers
sillers73822103sillers
soars54732513so__ars
sofars94712783so_fars
solans64122493so_lans
solar55927343so_lar_
soldans83210403soldans
solders83517773solders
solvers104414253solvers
sonars64818973so_nars
soucars938423soucars
sowars94318013so_wars
sowcars1236013sowcars
talars66021683_talars
tellers73717603tellers
tillers73418743tillers
toilers74116263toilers
tolans64319273to_lans
tolar55524113to_lar_
tolas54532773to_la_s
tollage82610163tollage
tollages92410193tollages
tollbar945453tollbar_
toller63819443toller_
tolls54728433toll__s
tollways1444133tollways
toolbars1044743toolbars
toolers74416503toolers
trollers83211213trollers
uvulars1044413uvulars
velars93913723_velars
villas96117263villa_s
volar86917413vo_lar_
volleys13316643volleys
volvas12447993volva_s
vulgars11306533vulgars
wallahs13409473wallahs
wallas95719393walla_s
willers103517913willers
wolfers13409633wolfers
wolvers13349313wolvers
woolers104214023woolers
yellers103912953yellers
yodlers11298923yodlers
yowlers13328923yowlers
zillahs1935383zillahs

Search took 10 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 Filter1786911340270.423422437.4
2DLD Change Limit1340273698.79615237.3
3Display Results3693690.1262928.6
 (SQL Overall)1786913699.34519121.6
 
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.