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

399 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
collates10301914(None) 
collages113514241collages
collate92919681collate_
collated113615061collated
cellmates1347512cellmates
chelates132713842chelates
cholates132414762cholates
ciliates10413452ciliates
cognates11311582cognates
collage102813762collage_
collaged12279972collaged
collagen11338572collagen
collagens12256032collagens
collapse1244272collapse
collapses1344682collapses
collards113310192collards
collared113211142collared
collaret103116702collaret
collarets11327332collarets
collars93816572colla_rs
collator10310372collator
collators11410342collators
colleges112410522colleges
colleted113011662colleted
collets93517902collet_s
collides113214472collides
collies94326582coll_ies
colligates1347712colligates
collimates1447972collimates
collocates1448122collocates
colludes11279222colludes
colocates13312852colocates
comates114123642co_mates
conflates14311132conflates
copulates132612462copulates
corelates11314862corelates
decollates13137152decollates
fellates11312752fellates
folates103218452fo_lates
foliates11412752foliates
gallates92815522gallates
oblates91913242_oblates
oleates7417832_oleates
pollutes1037612pollutes
solates73523852so_lates
solvates11249672solvates
tollages92410192tollages
tollgates1046052tollgates
toluates8138902toluates
ablates92416903_ablates
acolytes13168043aco_lytes
acrylates1446683acrylates
acylates1339743acylates
adulates9311913adulates
alates64833963__alates
ballades114211643ballades
ballutes1037523ballutes
bolases93315003bo_lases
boletes9316063bo_letes
bollards11339153bollards
bollixes1747203bollixes
bolloxes1736833bolloxes
borates94823013bo_rates
bullaces12299433bullaces
bullate93415073bullate_
calcites12313003calcites
calculates1498703calculates
califates14310113califates
callans94518473calla_ns
callants104112143callants
callas84526753calla__s
callees94117783call_ees
callets93821703callet_s
calloses10313393calloses
calluses1039323calluses
calottes10610083calottes
canulates11312873canulates
carates95630613c_arates
caseates10313713caseates
cates75951893c___ates
caudates11310263caudates
celestes10310013celestes
celibates1358633celibates
cellae84915933cella_e_
cellared11398793cellared
cellarer10317923cellarer
cellarers11236503cellarers
cellaret103713573cellaret
cellarets11246063cellarets
cellars93713693cella_rs
cellmate1237863cellmate_
cellules1036813cellules
cerates95428253c_erates
chelate122914893chelate_
chelated142610483chelated
chlorates142512273chlorates
chocolates1746783chocolates
cholate122114933cholate_
chollas123811353cholla__s
chordates1547683chordates
ciliate9514603ciliate_
ciliated11510953ciliated
citrates102315093citrates
clades94920463c__lades
claves115020063c__laves
cleated103417843c_leated
cleats84919313c_leat_s
cleaves124111623c_leaves
climates12311973climates
clodpates1444103clodpates
coagulates13137453coagulates
coalas87418963coala__s
coated94927043co__ated
coatee84327223co__atee
coatees93816553co__atees
coater84329573co__ater
coaters93525793co__aters
coatis85122603co__atis
coats75635003co__at_s
coaxes154715633co__axes
cobalts1139203cobalt_s
cobles104622883cobl__es
cockades1738433cockades
cocottes1238303cocottes
cocreates132611883cocreates
coelomates1497563coelomates
coelomes1239293coelomes
coequates2045853coequates
coesites101313093coesites
cogitates1247863cogitates
cognate10312203cognate_
cohobates1646523cohobates
coinages11310803coinages
coinmates1348343coinmates
colas75436773co_la__s
coleader1139183coleader
coleaders1237823coleaders
coleads102911423colea_ds
coles76055063co_l__es
coleuses1039723coleuses
colies84837053co_l_ies
colitis92617353co_litis
collagist1248013collagist
collapsed1443223collapsed
collar83816173colla__r
collard103712923colla_rd
collarless1243073collarless
collateral1244113collateral
collaterals1353383collaterals
collating12312763collating
collation11313993collation
collations12312853collations
colleagues1342933colleagues
collected1447973collected
collects12279783collects
colleen939543coll_een
colleens1036843colleens
college102410443college_
colleger11227933colleger
collegers12256843collegers
collet84030363coll__et
collide103214793collide_
collided12309803collided
collider113410423collider
colliders12298073colliders
collie83621993coll_ie_
collied103316673coll_ied
collier93618153coll_ier
colliers103613583colliers
colligate1248293colligate_
colligated1446273colligated
collimate1348163collimate_
collimated1556083collimated
collins93419833coll_ins
collinses1138283collinses
collocate1348663collocate_
collocated1546163collocated
collogues1246213collogues
colloids11310173colloids
collops112611753coll_ops
collotypes1753353collotypes
collude10337993collude_
colluded12296463colluded
colluder11276873colluder
colluders12285613colluders
colocate12313433colocate_
colocated1439613colocated
colognes11310603colognes
colones96124433co_lones
colonies103620013colonies
colpitis1247503colpitis
colter84625093co_l_ter
colters93522443co_l_ters
colts76633293co_l_t_s
colures9315143co_lures
colzas174010513colza__s
comakes154413643co_makes
comate104124843co_mate_
combated1539823combated
combater1439383combater
combaters1538113combaters
combats13311683combat_s
commutes143011893commutes
compares143816433compares
competes144117243competes
completes153212923completes
compotes144716513compotes
computes143914553computes
comrades13149773comrades
comtes106222813co__mtes
conatus9310463co_natus
concaves1538913concaves
conclaves1646543conclaves
conepates13912283conepates
conflate13311173conflate_
conflated1539333conflated
confutes1339843confutes
connate9315753connate_
connotes10311453connotes
consulates12711103consulates
contes84432913co__ntes
coolants1039943coolants
coolies93824963cool_ies
coolths1236013cool_ths
copemates1549483copemates
coplots11511593coplot_s
copulate122614113copulate_
copulated142710483copulated
cordages12310113cordages
cordate10315223cordate_
cordites11314623cordites
corelate10516013corelate_
corelated12411823corelated
corkages1539103corkages
corollate1148123corollate_
coronates1110816923coronates
corotates112714283corotates
corrades111211263corrades
correlates1248673correlates
corsages11310363corsages
costate94019273costate_
cotes76347843co___tes
cottages113310493cottages
coulees9315513coul_ees
coulter94115603coul_ter
coulters103614313coul_ters
courages11311393courages
courantes1148883courantes
couvades1435613couvades
covellites1554713covellites
cowages13310943co_wages
cowbanes1537423cowbanes
cowhages1736113cowhages
cowpats1437713cowpat_s
cowrites133011593cowrites
coyotes12410703co_yotes
crates85736063c__rates
creates95225203c_reates
cremates124216003cremates
cullays12347703culla_ys
cullets94015613cullet_s
cullies94419963cull_ies
cullises103111313cullises
culottes1076293culottes
cumulates13258973cumulates
curates95323833c_urates
cutlases1038033cutlases
cyanates13238433cyanates
cyclases1537133cyclases
dealates92716683dealates
decollate12137733decollate_
decollated14136283decollated
decolletes13123983decolletes
deflates123013943deflates
delates83526283_delates
dilates83220663_dilates
dollars83311023dolla_rs
dollies83620983doll_ies
dolmades1245463dolmades
donates83217223do_nates
elates65032363__elates
eluates72014683_eluates
emulates10312573emulates
epilates10313503epilates
fellate10313433fellate_
fellated1239563fellated
filiates11412663filiates
folate93320393fo_late_
foliages1247623foliages
foliate10513533foliate_
foliated1249913foliated
folles93820473foll__es
follies103618943foll_ies
formates132814293formates
gallate83417123gallate_
gelates83219583_gelates
goliaths1244223goliaths
hollaed11359853holla_ed
hollands12247273hollands
hollas94616903holla__s
hollies103420813holl_ies
holloes103818193holl_oes
hoplites13310543hoplites
illites72415013_illites
inflates11512193inflates
iodates8312903io_dates
iolites73819483io_lites
isolates8613513isolates
jollies143516273joll_ies
jollities1647873jollities
locates93218813lo_cates
lollies73116923loll_ies
malates93522603_malates
maleates103316343maleates
millages113212903millages
modulates1238053modulates
mollahs12328283molla_hs
mollies93420233moll_ies
moulages1138053moulages
mullites10411643mullites
notates72817483no_tates
oblate82214743_oblate_
ocellate1037863ocellate_
ocellated1245453ocellated
oleate6318883_oleate_
ollas54218283_olla__s
oolites72817843_oolites
opiates9312143_opiates
orates64328613_o_rates
oscillates1244773oscillates
ovulates1148523ovulates
oxalates1557063oxalates
palates93624933_palates
palliates11311033palliates
palpates122613063palpates
pillages113012613pillages
plates85432243__plates
poleaxes1767273poleaxes
pollacks1656373pollacks
pollards11299523pollards
pollees93215333poll_ees
pollenates1246743pollenates
pollices12410753pollices
pollinates1247303pollinates
pollster1037103pollster
pollsters1137173pollsters
pollute937383pollute_
polluted1135433polluted
polluter1035403polluter
polluters1135033polluters
populates132710673populates
prelates10418573prelates
pulsates1048813pulsates
reflates113115663reflates
relates73731433_relates
replates102919273replates
reslates83619503reslates
rotates72819773ro_tates
roulades957173roulades
slates64934063__slates
soilages9189673soilages
solaces93116133so_laces
solate64526073so_late_
solated83618023so_lated
soleplates1244973soleplates
solutes73515263so_lutes
solvate102710213solvate_
solvated12237443solvated
sorbates10311103sorbates
soulmates1147073soulmates
spoliates1138543spoliates
sublates10315003sublates
sulfates11310793sulfates
sullages939973sullages
tallages92312003tallages
tillages93011263tillages
tillites8312833tillites
toeplates1147183toeplates
tolanes74216313to_lanes
tolerates9312123tolerates
tollage82610163tollage_
tollgate946253tollgate_
toluate7159343toluate_
ullages838953_ullages
ululates848433ululates
vacillates1555713vacillates
vallate103016563vallate_
valuates112811203valuates
villages123010603villages
violates11311193violates
volplanes1444673volplanes
voltages1237253voltages
voltes94915583vo_l_tes
volutes102710983vo_lutes
volvate13317993volvate_
vorlages1236033vorlages
vulgates12237233vulgates
zoolater1746093zoolater
zoolaters1844983zoolaters

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.1731032896.0
2DLD Change Limit1461623998.29617618.4
3Display Results3993990.1562557.7
 (SQL Overall)1786913998.62520717.8
 
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.