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

218 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
crotched1642859(None) 
crotches153411301crotches
crotchet152711991crotchet
crouched16359141crouched
crutched16307461crutched
blotched1635652blotched
botched153611902_botched
broached16309122broached
clothed134010282clot_hed
clutched16356032clutched
coached153313842c_oached
couched154115792c_ouched
cranched163210412cranched
cratches153012542cratches
crochet143616662cro_chet
crocked164014432cro_cked
crotch133410082crotch__
crotchets16396302crotchets
crotchety19403812crotchety
crouches153711292crouches
crunched16328162crunched
crutches15359592crutches
frothed14288782frot_hed
grouched15356662grouched
grutched15284672grutched
hotched163610922_hotched
notched134210302_notched
retched133814272_retched
roached133211832_roached
rotche114311982_rotche_
rotches123515702_rotches
scootched1763962scootched
scotched16187932scotched
scratched1735392scratched
scrooched1763842scrooched
scrootched1842332scrootched
trothed114010972trot_hed
wretched17276532wretched
arched125717323ar__ched
avouched1743583avouched
batched154114243_batched
bitched153212923_bitched
blotches1537433blotches
botcher143613223_botcher
botches143716023_botches
branched163210453branched
breached163411643breached
breeched16337383breeched
britches15278683britches
broacher15329263broacher
broaches153211623broaches
broche133612103bro_che_
brooches15288193brooches
brothel12318193brot_hel
brother123311333brot_her
brunched16317853brunched
caboched1844043caboched
cached145419203c__ached
capuched1843743capuched
caroaches1637793caroaches
caroche1469243caro_che_
caroches15710693caro_ches
catcher143115823c_atcher
catches144320773c_atches
chocked194411613cho_cked
churched1934653churched
cinched153910863c_inched
clenched16257763clenched
cliched153711023c_liched
clinched16347383clinched
cloche134312373clo_che_
cloches144113713clo_ches
clocked164112833clo_cked
clothe114712993clot_he_
clothes124513813clot_hes
clotted104011823clot_ted
clotured11246163clotured
clutches15307923clutches
coacher143714123c_oacher
coaches144018693c_oaches
coacted123611613c_oacted
cocked155022563c_o_cked
conches144019813c_onches
cooches143515833c_ooches
corotated122810053corotated
coshed124217543c_o_shed
coted85033853c_ot__ed
coucher144515853c_oucher
couches144020473c_ouches
coughed143310903c_oughed
cowshed1637773c_owshed
cracked163514743cr_acked
cranches153114543cranches
crashed134214203cr_ashed
cratch134110793cratch__
crated94827773crat__ed
cratered1149683cratered
craunched1764023craunched
creche13310763cr_eche_
creches14313093cr_eches
creeshed1435693creeshed
cricked164814283cr_icked
croaked143710533cro_aked
crocheted1745313cro_cheted
crochets15359833cro_chets
crocket154615673cro_cket
crooked143910943cro_oked
crooned103813343cro_oned
cropped143812063cro_pped
crossed105313893cro_ssed
crosshead1543803crosshead
crouch133910203crouch__
crowded14418793cro_wded
crowed124717303cro__wed
crowned133912433cro_wned
cruncher15338073cruncher
crunches153711353crunches
crushed134111963cr_ushed
crutch13408243crutch__
cultches15316533cultches
cutches143216463c_utches
ditched143711903_ditched
douched144012113_douched
drenched15247913drenched
encroached1842683encroached
erotized1838553erotized
etched123613703__etched
fetched163710473_fetched
fletched17306693fletched
flitched17256293flitched
frenched17299433frenched
frocked17439333fro_cked
frother133110153frot_her
groschen1442973groschen
grottoed10234503grottoed
grouches14328213grouches
grutches14285853grutches
hatched163414463_hatched
hitched163312253_hitched
hootches1656973hootches
hotches153814363_hotches
hutched16359883_hutched
itched123812023__itched
kvetched2142783kvetched
latched133914063_latched
letched133912053_letched
matched153513963_matched
mooched153910533_mooched
mouched153612593_mouched
notcher123610933_notcher
notches123513653_notches
ouched124316933__ouched
patched153514623_patched
pitched153512923_pitched
poached154212403_poached
pooched152810083_pooched
pouched153612773_pouched
preached163412063preached
proceed12310553pro_ceed
protected14158653protected
ranched133113603_ranched
ratches123620463_ratches
ratchet124218333_ratchet
reached134619083_reached
retches123318513_retches
roaches123616213_roaches
rochet115423003_ro_chet
rocked135022323_ro_cked
rotated82715293_rotated
rotch105815933_rotch__
rotted74524433_rot_ted
rouche114714313_rouche_
rouches124217893_rouches
roughed124210943_roughed
ruched124314633_r_uched
scooched16206683scooched
scootches1635003scootches
scorched16187193scorched
scotches15179473scotches
scraiched1744203scraiched
scratcher1635443scratcher
scratches1647323scratches
screeched17114343screeched
scrooches1645703scrooches
scrootches1743323scrootches
scrunched1744033scrunched
scutched16186893scutched
sketched1835393sketched
slouched14206743slouched
smooched16185983smooched
smutched16165923smutched
snatched14157633snatched
snitched14166863snitched
soothed113712743soot_hed
splotched1742823splotched
stitched14148203stitched
stretched1546213stretched
switched17157133switched
tetched133010773_tetched
thatched1735433thatched
toothed113310243toot_hed
torched133511353_torched
touched134914963_touched
trenched14289853trenched
troche113112513tro_che_
trochee122613883tro_chee
troches123715343tro_ches
trocked144312243tro_cked
trotted83711283trot_ted
twitched17155033twitched
vouched163910563_vouched
watched163012823_watched
witched163012193_witched
worthed1437873wort_hed
wrathed14298523wrat_hed
wrenched17748133wrenched
wretches16257283wretches
writhed14389623writ_hed

Search took 8 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.406440125.6
2DLD Change Limit1461622186.95321021.4
3Display Results2182180.1701282.4
 (SQL Overall)1786912187.52923733.7
 
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.