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

174 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
creeshes133695(None) 
creeses93914621crees_es
creeshed1435691creeshed
breeches15258672breeches
cheeses123613102chees_es
crashes124618402cr_ashes
creases94020962creas_es
creches14313092cr_eches
creepies1239612creepies
creese84014332crees_e_
creesh11328332creesh__
cresses94219812cr_esses
crushes124215132cr_ushes
freshes133515822fr_eshes
reshes94124362_r_eshes
screeches1695652screeches
sneeshes1136512sneeshes
beeches143413883_beeches
brashes124518463br_ashes
breaches153714123breaches
breathes134212903breathes
breeched16337383breeched
breezes18318693bree_zes
brushes124014663br_ushes
calashes13310533calashes
caleches15269933caleches
caresses10314063caresses
carwashes1745773carwashes
cashes114729883c__ashes
ceases84427073c_eas_es
celestes10310013celestes
censes83721803c_ens_es
cerastes101111093cerastes
cereuses1049243cereuses
cerises94722253ceris_es
ceruses93716233cerus_es
cesses84221363c__esses
cheese113812763chees_e_
cheesed133910683chees_ed
cheesier1335963cheesier
cheesiest1436323cheesiest
cherishes1767563cherishes
chesses124112633c_hesses
choushes1637623choushes
clashes124017283c_lashes
clenches152910953clenches
cohoshes1635883cohoshes
coshes115022783c__oshes
cranches153114543cranches
crases85532313cr_as_es
crashed134214203cr_ashed
crasher124616163cr_asher
crashers134013233cr_ashers
cratches153012543cratches
crease85519573creas_e_
creased104315583creas_ed
creaser94415733creas_er
creasers103612833creasers
creasier103210193creasier
creasiest11229943creasiest
creates95225203cr_eates
creche13310763cr_eche_
credences1498143credences
creeds94714773cree__ds
creeks124812923cree__ks
creeled104012013cree_led
creels84416943cree__ls
creepages1444303creepages
creeped12329713cree_ped
creeper11339983cree_per
creepers12318633creepers
creepie1137483creepie_
creepier1236253creepier
creepiest1337063creepiest
creeps104213623cree__ps
creeshing1536243creeshing
cremates124216003cremates
cremes104517993cr_e_mes
crenelles1146733crenelles
crenshaw1642423crenshaw
crenshaws1741973crenshaws
creoles9913323cr_eoles
creosols1045723creosols
creosotes1145653creosotes
crepes105419343cr_e_pes
cresols939653cr_esols
cress75022833cr_es__s
cresset93319943cr_esset
cressets10309103cressets
crested103416533cr_ested
crests85218703cr_es_ts
cresyls1234753cr_esyls
crevasses1444133crevasses
crevices1536713crevices
crises84529433cr_is_es
crosses94220793cr_osses
crotches153411303crotches
crouches153711293crouches
cruises93514443cruis_es
crunches153711353crunches
cruses88127713cr_us_es
crushed134111963cr_ushed
crusher124412323cr_usher
crushers134010093cr_ushers
crutches15359593crutches
cuishes122810823c_uishes
curtesies1147523curtesies
cyeses11510123c_yes_es
deashes113313903_deashes
drenches14309803drenches
dresses83716173dr_esses
enmeshes1345343enmeshes
fleeches16287083fleeches
fleshes133913273_fleshes
freebees1345353freebees
freebies1337873freebies
freesias1146333freesias
freezes193310353free_zes
frenches163311633frenches
freshed143312593fr_eshed
freshen133010883fr_eshen
freshens14298313fr_eshens
fresher132612643fr_esher
freshest143010583fr_eshest
freshet133416643fr_eshet
freshets14298673fr_eshets
greases84816713greas_es
greenies9312673greenies
heresies11312693heresies
immeshes1543933immeshes
inmeshes1345613inmeshes
kneesies1245543kneesies
leashes103514403_leashes
leeches123911933_leeches
menshes12310443_menshes
meshes115019443__meshes
perishes13313753perishes
preaches153214893preaches
precesses13310463precesses
preemies12512193preemies
presses93523153pr_esses
prewashes1744753prewashes
rashes95330153_r_ashes
reaches123423203_reaches
recesses10312323_recesses
reechoes1338413_reechoes
reested82916233_reested
reests64618893_rees_ts
reeves94721493_ree_ves
refreshes1595953_refreshes
rehashes1436953_rehashes
relishes11311953_relishes
resees63827483_r_esees
reshoes102316033_r_eshoes
retches123318513_retches
reuses66025523_reus_es
rewashes1447033_rewashes
rushes94724363_r_ushes
screeched17114343screeched
screecher16144483screecher
screechers17143683screechers
seethes103613743_seethes
speeches1537413speeches
teethes103611653_teethes
threshes1437383threshes
trashes104119263tr_ashes
trenches133512603trenches
tresses73719543tr_esses
unmeshes1346153unmeshes
ureases74416723ureas_es
welshes13379093_welshes
wreathes14299893wreathes
wrenches163210233wrenches
wretches16257283wretches

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.420425454.8
2DLD Change Limit1461621747.65619091.2
3Display Results1741740.0632761.9
 (SQL Overall)1786911748.13921954.9
 
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.