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

210 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
collared11321114(None) 
cellared11398791cellared
collaged12279971collaged
collard103712921collar_d
collaret103116701collaret
collated113615061collated
bollard103210502bollar_d
cellarer10317922cellarer
cellaret103713572cellaret
cleared103612462c_leared
collage102813762collage_
collagen11338572collagen
collages113514242collages
collapsed1443222collapsed
collar83816172collar__
collards113310192collards
collarets11327332collarets
collars93816572collar_s
collate92919682collate_
collates103019142collates
colleted113011662colleted
collided12309802collided
collied103316672coll_ied
colluded12296462colluded
colored10313472co_lored
coloured1148312coloured
compared153811822compared
hollaed11359852holla_ed
hollered1237602hollered
pillared11228092pillared
pollard103511142pollar_d
pollarded1344702pollarded
allayed11138063_allayed
allured8299173_allured
ashlared1253933ashlared
blared95018243__blared
bleared104211253_bleared
bollards11339153bollards
bolled94722653boll__ed
bollixed1834483bollixed
bolloxed1834473bolloxed
calibred1335053calibred
called94126733call__ed
callused1135853callused
cared86050093c___ared
cellae84915933cella_e_
cellar84514983cellar__
cellarers11236503cellarers
cellarets11246063cellarets
cellars93713693cellar_s
celled94420323cell__ed
chared125423693c__hared
chelated142610483chelated
ciliated11510953ciliated
claret84026573c__laret
clawed125115073c__lawed
clayed125013043c__layed
cleaned103512003c_leaned
clearer93710823c_learer
cleated103417843c_leated
cleaved134010483c_leaved
cloaked14368543c_loaked
closured11266353closured
clotured11246163clotured
cloured103111543c_loured
clovered14187363clovered
coaled95022713co__aled
coalshed1435013coalshed
coalyard1444093coalyar_d
coated94927043co__ated
coaxed165612513co__axed
cochaired1743883cochaired
cockaded1836393cockaded
cockered17710213cockered
coffered1737673coffered
coheaded1536603coheaded
cohered133514693co_hered
coiled95123943coil__ed
colead94114643colea__d
coleader1139183coleader
coled85540763co_l__ed
coleseed1147403coleseed
collagens12256033collagens
collapse1244273collapse
collapses1344683collapses
collaring12310543collaring
collarless1243073collarless
collator10310373collator
collected1447973collected
colleen939543coll_een
college102410443college_
colleger11227933colleger
colleges112410523colleges
collet84030363coll__et
collide103214793collide_
collider113410423collider
collides113214473collides
collie83621993coll_ie_
collier93618153coll_ier
colliers103613583colliers
colliery13307363colliery
collies94326583coll_ies
colligated1446273colligated
collimated1556083collimated
collocated1546163collocated
collogued1344073collogued
colloid10312883coll_oid
collude10337993collude_
colluder11276873colluder
colludes11279223colludes
collyria1344823collyria
colocated1439613colocated
cologned1237153cologned
colorbred1443953colorbred
coloreds1138093co_loreds
colorer9312523co_lorer
colourer1037563colourer
colubrid1344413colubrid
columned1334923columned
colure8314163co_lure_
colures9315143co_lures
combated1539823combated
compare135814993compare_
comparer143611363comparer
compares143816433compares
comparted16338423comparted
compered153414923compered
concaved1636223concaved
conflated1539333conflated
congaed11399743conga_ed
conjured18117903conjured
cooled95224593cool__ed
coopered133310933coopered
coppered153410543coppered
copulated142710483copulated
cored85044223co___red
corelated12411823corelated
cornered11311133cornered
corraded12128293corraded
coshered14610293coshered
costard104113353costar_d
costarred1244703costarred
cottered112511733cottered
covaried1448003co_varied
covered133315293co_vered
coward12411673co_war_d
cowered133214653co_wered
cowled125218393cowl__ed
culled94022473cull__ed
cullied104012353cull_ied
cultured1137233cultured
declared1248743declared
decollated14136283decollated
dogeared1145793dogeared
dollar74110983dollar__
dollarized2144703dollarized
dollars83311023dollar_s
dolled83518073doll__ed
dollied93811143doll_ied
dolloped1234983dolloped
dullard936603dullar_d
fellated1239563fellated
flared105317603__flared
foliaged1344673foliaged
foliated1249913foliated
followed15146273followed
foulard11257283foular_d
fullered1236383fullered
glared84715193__glared
goliard936073goliar_d
holard10410573ho_lar_d
holland11349473holla_nd
holloaed12157393holloaed
holloed113812753holl_oed
hollooed12146493hollooed
hollowed15157023hollowed
jollied15349273joll_ied
lolled74315823loll__ed
lolloped1134463lolloped
mallard10310273mallar_d
moldered1237173moldered
mortared1137213mortared
oared65030653_o__ared
ocellated1245453ocellated
pillaged12298093pillaged
poleaxed1854823poleaxed
polkaed1435323polka_ed
pollards11299523pollards
polled94022003poll__ed
pollened1157783pollened
polluted1135433polluted
poulard10299733poular_d
poularde11276573poularde
roared75015393ro__ared
rolled74220243roll__ed
scolloped1443653scolloped
soared74324293so__ared
solaced102911063so_laced
solated83618023so_lated
soldered1038153soldered
solleret8512223solleret
solvated12237443solvated
tallaged10257923tallaged
tillered937443tillered
tollage82610163tollage_
tollages92410193tollages
tolled73819033toll__ed
ullaged937033_ullaged
volleyed1543533volleyed
volplaned1542733volplaned

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622107.42019698.4
3Display Results2102100.0802625.0
 (SQL Overall)1786912107.90622601.9
 
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.