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

166 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
collards11331019(None) 
bollards11339151bollards
collard103712921collard_
collars93816571collar_s
pollards11299521pollards
bollard103210502bollard_
cellars93713692cellar_s
coalyards1543532coalyards
coleads102911422colea_ds
collages113514242collages
collar83816172collar__
collared113211142collared
collaret103116702collaret
collarets11327332collarets
collates103019142collates
colloids11310172colloids
costards113510802costards
cowards1339612co_wards
dollars83311022dollar_s
dullards1045492dullards
foulards12266462foulards
goliards1045132goliards
holards1148432ho_lards
hollands12247272hollands
mallards1138322mallards
pollard103511142pollard_
poulards11288232poulards
ballads104212913balla_ds
ballyards1544993ballyards
billiards1245023billiards
boards94616933bo__ards
bombards1536493bombards
boyards13399323bo_yards
calcars11312653calcar_s
callans94518473calla_ns
callants104112143callants
callas84526753calla__s
callboards1544973callboards
callers94221963caller_s
canards10311203c_anards
cards85137933c___ards
cellar84514983cellar__
cellared11398803cellared
cellarer10317933cellarer
cellarers11236503cellarers
cellaret103713583cellaret
cellarets11246063cellarets
chards125119733c__hards
chollas123811353cholla__s
clads85722733c__la_ds
claros84015113c__laros
clears84116563c_lear_s
clochards1743823clochards
coalas87418963coala__s
coalers94419353coaler_s
coalyard1444093coalyard_
coheads13289233cohea_ds
coilers93619903coiler_s
colas75436773co_la__s
colds85726973co_l__ds
colead94114643colea_d_
collage102813763colla_ge
collaged12279973collaged
collagen11338583collagen
collagens12256043collagens
collagist1248023collagist
collapse1244273collapse
collapses1344683collapses
collaring12310563collaring
collarless1243073collarless
collate92919683colla_te
collated113615063collated
collator10310373collator
collators11410343collators
collects12279783collects
colleens1036843colleens
colleges112410523colleges
collets93517903coll_ets
collide103214793coll_ide
collides113214473collides
collied103316683collied_
colliers103613583colliers
collies94326583coll_ies
collins93419833coll_ins
colloid10312883colloid_
collops112611753coll_ops
collude10337993coll_ude
colludes11279223colludes
collyria1344823collyria
colombards1752483colombards
colorado1145933colorado
coloreds1138093coloreds
colors86622373co_lor_s
colours95913443colour_s
colters93522443colter_s
colubrids1443603colubrids
colures9315143co_lures
colzas174010513colza__s
commands15318823commands
compares143816433compares
comparts144210833comparts
concords1358603concords
conelrads1244263conelrads
coolants1039943coolants
coolers93522493cooler_s
cords86030623co___rds
costard104113353costard_
costars94218013costar_s
cottars94412243cottar_s
cougars1038443cougar_s
coward12411673co_ward_
cowbirds1644043cowbirds
cowhands1765263cowhands
cowherds1735423cowherds
croplands1445373croplands
cullays12347703culla_ys
cullers93418853culler_s
custards11338393custards
dollar74110983dollar__
dotards937253do_tards
dullard936603dullard_
forwards1537043forwards
foulard11257283foulard_
galliards1194543galliards
goldarns1043593goldarns
goliard936073goliard_
halliards13104933halliards
halyards1576243halyards
hoards104912623ho__ards
holard10410573ho_lard_
hollaed11359853hollaed_
holland11349473holland_
hollas94616903holla__s
hollers103818233holler_s
lallands9338583lallands
lards65331863___lards
liards75212613__liards
lollers72713793loller_s
lowlands1244373lowlands
mallard10310273mallard_
milliards1246193milliards
molars85517323mo_lar_s
mollahs12328283molla_hs
norlands936443norlands
oculars948363ocular_s
ollas54218283_olla__s
onwards1137173_onwards
paillards1244983paillards
pillars9313493pillar_s
pochards1646853pochards
polars84419353po_lar_s
pollacks1656373pollacks
pollarded1344703pollarded
pollers93420023poller_s
poniards1145823poniards
poplars113910333poplar_s
poulard10299733poulard_
poularde11276573poularde
poulardes12286183poulardes
rollers73117473roller_s
solands84412343so_lands
tolars64817943to_lar_s
tollages92410193tollages
tollbars1045443tollbar_s
tollers73217463toller_s
towards1138783to_wards

Search took 9 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 Limit1461621667.78018786.9
3Display Results1661660.0632634.9
 (SQL Overall)1786911668.24921662.1
 
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.