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

271 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
crummy1536589(None) 
chummy18385891chummy
crumby15408111crumby
rummy124212411_rummy
brumby15385952brumby
chammy18488952chammy
clammy15356332clammy
clumpy15409572clumpy
clumsy13326192clumsy
commy144712642c_ommy
crampy154710992crampy
creamy134811362creamy
crimpy15489392crimpy
cruddy1334192cruddy
crumb114313592cru_mb
crumbly16347522crumbly
crumbs12409232crumbs
crummie1336152crummie
crump115616422cru_mp
crumply16336092crumply
crumps124514342crumps
crusty114911342crusty
drumly1235702drumly
dummy134712782_dummy
frumpy16466882frumpy
gremmy1454472gremmy
grumpy14498152grumpy
gummy135413652_gummy
mummy114913622_mummy
plummy15375662plummy
rammy124312492_rammy
scummy15265222scummy
slummy13325862slummy
thrummy1742172thrummy
tummy124711992_tummy
yummy15429152_yummy
army96624183ar__my
arum66129033aru_m_
arums75517833aru_ms
broomy13449953broomy
brumal1049503brumal
brume95817983bru_me
brumes106417073brumes
brushy14468263brushy
bumpy144715053_bumpy
calmly1337613calmly
calumny1443863calumny
campy145116183c_ampy
causey113513273causey
cerumen1147763cerumen
champy18509613champy
chasmy16468543chasmy
chromy16309903chromy
chubby1844123chubby
chucky20418003chucky
chuffy20445863chuffy
chum116318003chu_m_
chummed17396443chummed
chummily2042843chummily
chump145315443chu_mp
chumps154313823chumps
chums125015833chu_ms
chunky18468273chunky
clubby1534683clubby
clump115517453clu_mp
clumps1215314643clumps
clunky15447893clunky
comfy153710213c_omfy
comma114514793c_omma
county114313323county
crabby15346753crabby
cracky175010223cracky
crafty14478913crafty
craggy13396603craggy
cram85635493cr_am_
crambe1239073crambe
crambo1238043crambo
crammed143710123crammed
crammer134010963crammer
cramp115120693cr_amp
cramps125615563cramps
crams96229153cr_ams
cranky153910633cranky
cranny114210273cranny
crappy15446803crappy
crawly144610763crawly
crazy195511223cr_azy
creaky154911553creaky
cream95721353cream_
creams104715253creams
creasy114612303creasy
creepy13418803creepy
creme94319323cr_eme
cremes104517993cremes
crepey135110933crepey
crepy124812703cr_epy
cressy11439113cressy
crikey15317783crikey
crime94822693cr_ime
crimes105521583crimes
criminy14268453criminy
crimmer133310773crimmer
crimp115615803cr_imp
crimps124613453crimps
crispy13478563crispy
croaky15528483croaky
crony105918673cr_ony
croupy13458733croupy
crowdy15467173crowdy
cru57129563cru___
cruces105117543cruces
crucify1744063crucify
cruck135615323cru_ck
crucks144412583crucks
crud75219613cru__d
crude86018573cru_de
crudely1336273crudely
cruder95612383cruder
crudes96218623crudes
crudity1336043crudity
cruds85815853cru_ds
cruel74815903cru_el
cruelly1236563cruelly
cruelty1234113cruelty
cruet74831843cru_et
cruets85314953cruets
cruise84314043cruise
crumbed14378473crumbed
crumber13339643crumber
crumble133410403crumble
crumbum1543743crumbum
crumbums1642733crumbums
crummier1435603crummier
crummies1437643crummies
crumped144311223crumped
crumpet133711063crumpet
crumple13368363crumple
crunch13349503crunch
crunchy17324763crunchy
cruor7310453cru_or
cruors838643cruors
crura7312583cru_ra
crural8610633crural
crus65828483cru__s
cruse75726103cru_se
cruses88127713cruses
cruset84425093cruset
crush106815993cru_sh
crusily12199093crusily
crust75827663cru_st
crusts84916543crusts
crutch13408243crutch
crux135415003cru__x
cruxes154911563cruxes
cry89726243cr___y
cubby145212123c_ubby
cuddy125111973c_uddy
cully105520463c_ully
culm85822383c_ulm_
culms95314193c_ulms
cum76440163c_u_m_
cumin94616973c_umin
cummer124414593c_ummer
cummin1288783c_ummin
cuppy144710383c_uppy
curacy1339593curacy
curdy115916523c_urdy
curly105321233c_urly
curry105920343c_urry
curtly1149283curtly
curtsy1156643curtsy
curvey144111843curvey
curvy136013373c_urvy
cushy134412323c_ushy
cutey105819793c_utey
cutty105417223c_utty
dreamy12509993dreamy
druggy12344743druggy
drum76521593dru_m_
drummed13306323drummed
drummer12407503drummer
drums85415873dru_ms
dumky154511343_dumky
dumpy135414753_dumpy
emmy116013243__emmy
fruity12429693fruity
frump126912563fru_mp
frumps13479783frumps
fumy127118583_fu_my
gammy135514893_gammy
gemmy135211053_gemmy
glumly12356623glumly
glumpy14527193glumpy
gramma11499803gramma
gramme114210333gramme
grimly12459933grimly
grimy114312603gr_imy
grubby14324503grubby
gruffy16396013gruffy
grum75625083gru_m_
grumbly15355403grumbly
grume86218163gru_me
grumes94415553grumes
grummer12338783grummer
grummet12298873grummet
grump105115313gru_mp
grumphy18443623grumphy
grumps114510573grumps
grungy11345973grungy
gumma105313103_gumma
hammy155113433_hammy
haulmy14455553haulmy
humpy155115673_humpy
immy114611833__immy
jammy194810193_jammy
jemmy19498553_jemmy
jimmy19538503_jimmy
jumpy195712813_jumpy
lumpy126615913_lumpy
mammy115215163_mammy
mommy114010753_mommy
mumm75718863_mumm_
mumms85513153_mumms
plumy124213233plu_my
pommy14449863_pommy
primly13439623primly
rimy96621283_r_imy
roomy107118063_roomy
rubby124413863_rubby
ruby97819943_ru_by
ruddy104511753_ruddy
rugby11448133_rugby
ruly76323143_ru_ly
rum56644643_ru_m_
rumba93612513_rumba
rumbly134412163_rumbly
rumen74419503_rumen
rummer104715483_rummer
rumor71011323_rumor
rump86729083_ru_mp
rumply13348573_rumply
rumps95922293_rumps
rums64833473_ru_ms
runny84613483_runny
runty86119043_runty
rushy115414813_rushy
rusty85221053_rusty
rutty85617803_rutty
scrimpy16486133scrimpy
scrubby1642803scrubby
scruffy1842643scruffy
scrum95418203scru_m_
scrummed1554313scrummed
scrums104614253scru_ms
shammy16388503shammy
shimmy16306413shimmy
spumy124610363spu_my
stemmy13417033stemmy
stumpy13458133stumpy
summa94713313_summa
swimmy16234353swimmy
tammy124013223_tammy
tommy124712233_tommy
trampy13499253trampy
trimly114410893trimly
truly84111553tru_ly
trump95615123tru_mp
trumps104611883trumps
trusty94710113trusty
umm711921263__umm_
whammy19375293whammy

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162715.17321789.3
3Display Results2712710.0763565.8
 (SQL Overall)1786912715.62231784.2
 
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.