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 “comped” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

172 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
comped13591987(None) 
camped134720231camped
chomped17329771chomped
clomped14398971clomped
combed135516541combed
compel124412891compel
compend144010301compend
compted143813521compted
cooped114821601cooped
coped105036841co_ped
copped135221251copped
couped115019311couped
romped114513651romped
amped104820512_amped
bombed134113872bombed
bopped134413402bopped
bumped134414002bumped
camper124722212camper
caped104931802c_aped
capped134721852capped
carped115923762carped
champed174111482champed
chomper163810072chomper
chopped174511002chopped
chumped17379492chumped
clamped144012042clamped
cleped115114112cleped
clopped143611522clopped
clumped143610662clumped
coaled95022712coaled
coapted123911502coapted
coated94927042coated
coaxed165612512coaxed
cocked155022562cocked
codded114515302codded
coded95433182co_ded
coed77140542co__ed
coempted1535332coempted
cogged116416612cogged
coifed124113062coifed
coiled95123942coiled
coined94523602coined
coked124730692co_ked
coled85540762co_led
comade114415322comade
comae97128422comae_
combe116223542combe_
comber125118502comber
combes125321732combes
come87547702com_e_
comedo11359602com_edo
comedy14378232com_edy
comer95832692com_er
comes97246992com_es
comet95946072com_et
commend144010182commend
comp106731252comp__
compared153811822compared
compas125817062compas
compeer133811552compeer
compels133210882compels
compends15378252compends
compere134616622compere
compered153414922compered
compete134716552compete
competed154113592competed
compiled1537812compiled
complex2037242complex
complied1539672complied
comply152810382comply
compo115318572comp_o
compos124818802compos
composed154612062composed
comps115526052comp_s
compt116328222comp_t
compts125216652compts
computed154110952computed
comte96125472comte_
comtes106222812comtes
coned86040052co_ned
conked135019112conked
conned95119702conned
cooed84534342co_oed
cooeed95917862cooeed
cooked135921362cooked
cooled95224592cooled
cooper104221122cooper
coopted123710762coopted
cope86847382co_pe_
copen94826432co_pen
coper95336092co_per
copes97747102co_pes
copied114618562copied
copper124321892copper
corded105923352corded
cored85044222co_red
corked135020782corked
corned95224522corned
coshed124217542coshed
cosied94819882cosied
costed95623112costed
coted85033852co_ted
coupe96023482coupe_
coupes105022522coupes
coupled124312672coupled
coved115027372co_ved
cowed115637852co_wed
cowled125218392cowled
cowpea1337642cowpea
coxed154322812co_xed
coyed114623802co_yed
cozied184112152cozied
cramped144712182cramped
craped116120522craped
creped114115702creped
crimped143910762crimped
cropped143812062cropped
crumped144311222crumped
cupped134413982cupped
cusped114312042cusped
damped124315582damped
domed95423262dom_ed
doped95326712do_ped
dumped123814492dumped
fopped144012672fopped
gimped123911472gimped
homed115425422hom_ed
hooped125518182hooped
hoped115628182ho_ped
hopped144318112hopped
humped144015242humped
imped105117982_imped
jumped183511552jumped
lamped114017542lamped
limped114817122limped
looped95217172looped
loped85128332lo_ped
lopped114218622lopped
louped95316382louped
lumped114216962lumped
moped105424732mo_ped
mopped134114322mopped
mumped133813162mumped
oped76230152_o_ped
pimped134913482pimped
pooped113915942pooped
popped104117812popped
pumped133915562pumped
ramped114617902ramped
romper104213682romper
roped84630802ro_ped
rouped95717352rouped
scamped144711962scamped
scooped124611742scooped
scoped115116652sco_ped
soaped95817972soaped
sopped114819902sopped
souped95017672souped
stomped124110532stomped
tamped114317042tamped
temped113912892temped
tombed113812132tombed
tommed113310142tommed
toped85631312to_ped
topped114617722topped
tromped124210292tromped
tumped114216232tumped
umped104717272_umped
vamped144211012vamped
whomped18345472whomped
wimped144211512wimped
wombed14419232wombed

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511722.23636919.1
3Display Results1721720.0602866.7
 (SQL Overall)1786911722.63967711.6
 
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.