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

247 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
collard10371292(None) 
bollard103210501bollard
collar83816171collar_
collards113310191collards
collared113211141collared
collars93816571collars
pollard103511141pollard
bollards11339152bollards
cellar84514982cellar_
cellared11398792cellared
cellars93713692cellars
coalyard1444092coalyard
colead94114642colea_d
collage102813762collage
collaged12279972collaged
collaret103116702collaret
collate92919682collate
collated113615062collated
collied103316672collied
colloid10312882colloid
costard104113352costard
coward12411672co_ward
dollar74110982dollar_
dollars83311022dollars
dullard936602dullard
foulard11257282foulard
goliard936072goliard
holard10410572ho_lard
hollaed11359852hollaed
holland11349472holland
mallard10310272mallard
pollards11299522pollards
poulard10299732poulard
ballad94315323balla_d
ballyard1445893ballyard
billiard1145873billiard
board85523003bo__ard
bolar75123473bo_lar_
bolled94722653boll_ed
bombard1437333bombard
boyard125411283bo_yard
calcar10312753calcar_
calcars11312653calcars
calla74827073calla__
callan83619603calla_n
callans94518473callans
callant94121223callant
callas84526753calla_s
callboard1445663callboard
called94126733call_ed
caller85125483caller_
callers94221963callers
calvary1537183calvary
canard9314763c_anard
card710245873c___ard
cella75420313cella__
cellae84915933cella_e
cellarer10317923cellarer
cellaret103713573cellaret
celled94420323cell_ed
chard116124743c__hard
cholla113911023cholla__
chollas123811353cholla_s
ciliary1247923ciliary
clad76225823c__la_d
claro75018693c__laro
clary105719613c__lary
clear76219053c_lear_
cleared103612463c_leared
clears84116563c_lears
clochard1644293clochard
coala77521123coala__
coalas87418963coala_s
coaled95022713coal_ed
coaler84121713coaler_
coalers94419353coalers
coalyards1543533coalyards
cohead123811123cohea_d
coiled95123943coil_ed
coiler84421593coiler_
coilers93619903coilers
cola66541393co_la__
colas75436773co_la_s
cold77338773co_l__d
colder95121853colder_
coleads102911423coleads
coled85540763co_l_ed
collagen11338573collagen
collages113514243collages
collapse1244273collapse
collapsed1443223collapsed
collarets11327333collarets
collaring12310543collaring
collates103019143collates
collator10310373collator
collators11410343collators
collect113314593collect
colleen939543colleen
college102410443college
collet84030363coll_et
colleted113011663colleted
collets93517903collets
collide103214793collide
collided12309803collided
collie83621993coll_ie
collier93618153collier
colliers103613583colliers
colliery13307363colliery
collies94326583collies
collins93419833collins
colloids11310173colloids
collop107312313coll_op
collops112611753collops
collude10337993collude
colluded12296463colluded
colly104926773coll__y
collyria1344823collyria
colombard1643153colombard
color76123743co_lor_
colorado1145933colorado
colored10313473colored
colors86622373co_lors
colour85915093colour_
coloured1148313coloured
colours95913443colours
colter84625093colter_
colters93522443colters
colubrid1344413colubrid
colure8314163co_lure
colza165112983colza__
colzas174010513colza_s
command14399213command
compare135814993compare
compared153811823compared
compart134016003compart
concord12510343concord
conelrad1145603conelrad
congaed11399743congaed
coolant9316463coolant
cooled95224593cool_ed
cooler84824713cooler_
coolers93522493coolers
copular113810603copular_
cord76740923co___rd
corollary1443913corollary
costar85518613costar_
costards113510793costards
costars94218013costars
cottar84613813cottar_
cottars94412243cottars
cougar958783cougar_
cougars1038443cougars
could86517713coul__d
covary1438743co_vary
cowards1339613co_wards
cowbird1534433cowbird
cowhand1665933cowhand
cowherd1636953cowherd
cowled125218393cowl_ed
cropland1346303cropland
cullay113910173culla_y
cullays12347703cullays
culled94022473cull_ed
culler84322253culler_
cullers93418853cullers
cullied104012353cullied
custard10389973custard
dolled83518073doll_ed
dollied93811143dollied
dotard839053do_tard
dullards1045493dullards
foliar93210973foliar_
forward1438293forward
foulards12266463foulards
galliard10125753galliard
goalward1343493goalward
goldarn944383goldarn
goliards1045133goliards
halliard12125963halliard
halyard1476973halyard
hoard94918313ho__ard
holards1148433ho_lards
holla84918493holla__
hollands12247273hollands
hollas94616903holla_s
holler93520613holler_
hollered1237603hollered
hollers103818233hollers
holloaed12157393holloaed
holloed113812753holloed
jollied15349273jollied
lalland83810183lalland
lard56742003___lard
liard65418593__liard
lolled74315823loll_ed
loller63315283loller_
lollers72713793lollers
lowland1134693lowland
lyard95113213__lyard
mallards1138323mallards
milliard1147033milliard
molar75223093mo_lar_
molars85517323mo_lars
mollah11319453molla_h
mollahs12328283mollahs
norland837163norland
ocellar936533ocellar_
ocular8610133ocular_
oculars948363oculars
olla44821173_olla__
ollas54218283_olla_s
onward1039053_onward
paillard1146263paillard
pillar8314023pillar_
pillared11228093pillared
pillars9313493pillars
pochard1537363pochard
polar75623453po_lar_
polars84419353po_lars
poleward1455943poleward
polkaed1435323polkaed
pollack1567333pollack
pollarded1344703pollarded
polled94022003poll_ed
poller83921853poller_
pollers93420023pollers
poniard1037583poniard
poplar103611113poplar_
poplars113910333poplars
poularde11276573poularde
poulards11288233poulards
rolled74220243roll_ed
roller63919793roller_
rollers73117473rollers
soland75115043so_land
solar55927343so_lar_
tolar55524113to_lar_
tolars64817943to_lars
tollage82610163tollage
tollbar945453tollbar_
tollbars1045443tollbars
tolled73819033toll_ed
toller63819443toller_
tollers73217463tollers
toward10311063to_ward
volar86917413vo_lar_
willyard1543963willyard

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272476.09321996.9
3Display Results2472470.0803087.5
 (SQL Overall)1786912476.56327227.0
 
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.