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

374 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
collops11261175(None) 
collop107312311collop_
dollops10287961dollops
lollops9227441lollops
scollops12235691scollops
callous93516592callous
cellos84517802cello_s
clops95924852c__lops
coeloms1139062coeloms
collapse1244272collapse
collars93816572collars
collets93517902collets
collies94326582collies
collins93419832collins
colloid10312872colloid
colloids11310172colloids
cologs96517352co_logs
colons86028682co_lons
colors86622372co_lors
coops96229642co__ops
coplots11511592coplots
cowflops1842982cowflops
cowplops1743172cowplops
cyclops1635382cyclops
dollop9259362dollop_
follows13409922follows
gallops103211652gallops
holloas103814942holloas
holloes103818192holloes
holloos104013582holloos
hollos95320632hollo_s
hollows134412332hollows
lollop8238782lollop_
lollopy12234772lollopy
orlops847302_orlops
rollmops1243002rollmops
scallops12297372scallops
scollop11275432scollop_
trollops1044802trollops
wallops123410412wallops
acoelous1047023acoelous
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
apollos946793apollo_s
ballons93916953ballons
ballots94116033ballots
bellhops1544873bellhops
bellows124313303bellows
billons93013353billons
billows123611283billows
bloops106611343_bloops
bollocks1636503bollocks
bollox1548743bollo_x
bolloxes1736833bolloxes
bolls75531313boll__s
bolos75531373bo_lo_s
bolsons969483bolsons
bullous9311663bullous
callans94518473callans
callas84526753call_as
callboys1585173callboys
callees94117773callees
callers94221963callers
callets93821703callets
calliope1256223calliope
calliopes1346143calliopes
callose9313653callose
calloses10313383calloses
callow114714663callo_w
calls75634733call__s
callus85317073call_us
calos74431903c_alo_s
caltrops12307863caltrops
carhops14329703carhops
cellars93713693cellars
cello74919583cello__
cells75428063cell__s
celoms10412123c_eloms
chollas123811353choll_as
cholos114716853cholo_s
chops125019873c__hops
chylous15107263chylous
clamps124515083c_lamps
claps95626183c__laps
clasps104512093c_lasps
clips96018303c__lips
clods85320863c__lods
clogs85519553c__logs
clomps125212233c_lomps
clons75228133c__lons
cloots85113693c_loots
clop86929893c__lop_
clots75627643c__lots
cloys104916943c__loys
clumps1215314643c_lumps
coalas87418963coal_as
coalers94419333coalers
coalless1038193coalless
coals76129603coal__s
cobles104622883cobl_es
coccous1038993coccous
cockups1735223cockups
cocoas104915743co_coas
cocoons11310563cocoons
cocos95624693co_co_s
codlins104116243codlins
codons96119463co_dons
coelom10310423coelo_m
coelome1139683coelome
coelomes1239293coelomes
cogons96818113co_gons
cohogs125810273co_hogs
cohos105921853co_ho_s
coilers93619903coilers
coils75030083coil__s
colas75436773co_l_as
colbys13407153co_lbys
colds85726973co_l_ds
coleads102911423coleads
coles76055063co_l_es
coleus86818273co_leus
colics104219903co_lics
colies84837053co_lies
colins85229043co_lins
colitis92617343colitis
collage102813753collage
collages113514233collages
collapsed1443223collapsed
collapses1344683collapses
collar83816173coll_ar
collard103712923collard
collards113310193collards
collate92919683collate
collates103019133collates
collators11410323collators
collect113314593collect
collects12279783collects
colleen939533colleen
colleens1036843colleens
college102410433college
colleges112410513colleges
collet84030363coll_et
collide103214783collide
collides113214463collides
collie83621993coll_ie
collied103316673collied
collier93618153collier
colliers103613583colliers
collogue1145463collogue
collogues1246213collogues
colloquy2243033colloquy
collotype1643383collotype
collotypes1753353collotypes
collotypy1952103collotypy
collude10337983collude
colludes11279213colludes
colly104926773coll__y
colobi105011083co_lobi
colobus11389373colobus
colog86619933co_lo_g
colon78630193co_lo_n
colone85425003co_lone
colones96124433colones
coloni85619203co_loni
colonus94413443colonus
colony115417273co_lony
color76123743co_lo_r
colossi935673co_lossi
colour85915083co_lour
colours95913413colours
cols66553083co_l__s
colters93522433colters
colts76633293co_l_ts
colugos1035693colugos
columns1136473columns
colures9315133colures
colzas174010503co_lzas
combos125316613combo_s
commons13311043commons
comous10816503co_mous
complots1438163complots
compos124818803compo_s
comps115526053co__mps
condoes104319203condoes
condoms124214083condoms
condors104018553condors
condos94322333condo_s
congoes103617303congoes
congos94219883congo_s
congous103615083congous
consols92914073consols
contos84923233conto_s
convoys15267023convoys
coofs105924713co__ofs
cooks115429143co__oks
cooktops1644063cooktops
coolers93522493coolers
coolies93824963coolies
cools75632633co__ols
coolths1236013coolths
coons76737283co__ons
coop87238653co__op_
coopt95929853co__opt
coopts105814583co__opts
coos67456493co__o_s
coots75636843co__ots
copilots1255753copilots
copious11311963copious
coplot10518273coplo_t
cops86751373c___ops
cordons104415763cordons
cormous11312353cormous
corps95927043co__rps
cosmos10311753cosmo_s
cotillons1144633cotillons
cottons9312193cottons
coulees9315503coulees
coulis84018753coul_is
couloir936143couloir
couloirs1045983couloirs
coulomb1344553coulomb
coulombs1443093coulombs
coupons112710553coupons
coups95522473co__ups
cowboys1735253cowboys
cowflaps1842293cowflaps
cowflop1742893cowflop_
cowls106922213cowl__s
cowplop1643363cowplop_
cowslips1543613cowslips
coxless1637743coxless
coydogs1434493coydogs
coypous14248813coypous
criollos1043713criollo_s
crops96125233c__rops
cullays12347703cullays
cullers93418843cullers
cullets94015613cullets
cullies94419963cullies
cullions10219213cullions
cullis84115993cull_is
culls75425813cull__s
cyclopes1746263cyclopes
cyclos1338073cyclo_s
doblons1037043doblons
dollars83311023dollars
dollies83620983dollies
dolloped1234983dolloped
dolls66126923doll__s
dolors75115313do_lors
doowops1363943doowops
escallops1343173escallops
fallows133713973fallows
felloes104114373felloes
fellows134212433fellows
fillips12298133fillips
fillos94415073fillo_s
flops105920143__flops
foldups1332733foldups
folios93915463folio_s
folious103710733folious
folles93820473foll_es
follies103618943follies
follis93113903foll_is
follow124010353follo_w
followups1742293followups
gallons83015943gallons
gallop93311383gallop_
gallous82813953gallous
gallows113513513gallows
galops94712613_galops
glops85619553__glops
goops86620963go__ops
halloas104318463halloas
halloes104021513halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
helloes103717453helloes
hellos95321683hello_s
hilloas104413543hilloas
hilloes103815943hilloes
hillos94618883hillo_s
hilltops1344913hilltops
holdups1333593holdups
hollas94616903holl_as
hollers103818233hollers
hollies103420813hollies
hollo84822163hollo__
holloa94914823hollo_a
holloed113812753holloed
holloo94415253hollo_o
hollow124212663hollo_w
hoops105621073ho__ops
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
jalops15329593_jalops
jellos134714283jello_s
jollies143516273jollies
joypops2162603joypops
kolos94921213ko_lo_s
lollers72713793lollers
lollies73116923lollies
lollipops1341783lollipops
lolloped1134463lolloped
lolls512121733loll__s
lollypops1651953lollypops
loops75723963__loops
lops66043353___lops
mallows123714323mallows
mellows123812233mellows
mollahs12328283mollahs
mollies93420233mollies
molls75129783moll__s
nolos54423353no_lo_s
ocelots977233ocelots
oleos55419683_oleo_s
olios54520853_olio_s
ollas54218283_oll_as
oops65232673_o__ops
orlons6411013_orlons
orlop7410903_orlop_
oxlips1544433_oxlips
pallors9314343pallors
pillows122610103pillows
plops95920333__plops
polios84019723polio_s
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
pollock1546843pollock
pollocks1656473pollocks
polls74627723poll__s
polos76129913po_lo_s
polyols1238493polyols
polyps13479763po_lyps
poops94422413po__ops
postops11311703postops
pullups1134233pullups
rollers73117473rollers
rollmop1142993rollmop_
rollout7811943rollout
rollouts8136723rollouts
rolls55326233roll__s
rolltop944043rolltop_
sallows103915543sallows
saloops93510133saloops
scallop11237643scallop_
scolloped1443653scolloped
scoops105414363sco__ops
shallops13288313shallops
sloops85513623_sloops
slops75026013__slops
solions7513743solions
solons65120013so_lons
solos54830793so_lo_s
tallols73311353tallols
tallows103313733tallows
tollers73217453tollers
tolls54728433toll__s
toluols735823toluols
trollop944793trollop_
trollopy1343273trollopy
villous102810013villous
volleys13316643volleys
wallop113310293wallop_
wallows133613533wallows
willows13299743willows
woops104917523wo__ops
yellows13329603yellows

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340273747.73317331.8
3Display Results3743740.1262968.3
 (SQL Overall)1786913747.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.