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

137 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
scooching173507(None) 
scootching1843361scootching
scorching1735631scorching
scotching1735651scotching
scrooching1843321scrooching
smooching1734881smooching
coaching164011962_coaching
couching163213262_couching
mooching16259062_mooching
pooching16328982_pooching
sconcing1338262sconc_ing
scooping133610632scoo_ping
scooting113012642scoo_ting
scrootching1951892scrootching
scutching1735222scutching
slouching15195722slouching
smooshing1534792smooshing
smoothing1535292smoothing
soochong14104372s_oochong
soothing12269972s_oothing
swooshing1643882swooshing
avouching1843273avouching
bescorching2142283bescorching
blotching1734963blotching
botching16359703_botching
broaching17287663broaching
caching156317503_c_aching
catching163712773_catching
chocking204011013_chocking
cinching163310223_cinching
clocking174312413_clocking
clothing14278783_clothing
coacting133412703_coacting
cochin131313203_c_ochin_
cochins141413103_c_ochins
cocking163619983_c_ocking
cooeeing1137453_cooeeing
cooeying1438143_cooeying
cooing94024923_coo__ing
cooking143818973_coo_king
cooling103422573_coo_ling
cooping123918933_coo_ping
coopting133411313_coopting
coshing134316433_c_oshing
couchings17285763_couchings
coughing15309213_coughing
crocking174313443_crocking
crouching1746383crouching
douching15349843_douching
grouching1644943grouching
hotching17309313_hotching
mouching163110583_mouching
notching14288583_notching
oohing104412933__oo_hing
ouching134314903__ouching
poaching163510833_poaching
poohing133112323_poo_hing
pouching163210413_pouching
roaching143210433_roaching
scarphing1735243scarphing
scathing14269703sc_athing
schooling1546943schooling
scoffing17275943sc_offing
scolding12278913sc_olding
scooch13228123scooch___
scooched16206683scooch_ed
scooches15188413scooch_es
scoping123513823sc_o_ping
scorchingly2252063scorchingly
scoring103117213sc_o_ring
scorning1169133sc_orning
scourging1334573scourging
scouring112810853sc_ouring
scouting112612753sc_outing
scowing133812093sc_o_wing
scowling1458293sc_owling
scraiching1843793scraiching
scratching1844533scratching
screeching1843643screeching
scrolling12187803scrolling
scrooping1446593scrooping
scrouging1335263scrouging
scrunching18163473scrunching
scything17264883sc_ything
searching1538343searching
shocking184311543s_hocking
shooing112112913shoo__ing
shooling123012563shoo_ling
shooting122812863shoo_ting
sketching1935083sketching
sloshing12258823s_loshing
sloughing14244753sloughing
smirching1744393smirching
smocking17349103s_mocking
smutching1734853smutching
snatching1536363snatching
snitching1535913snitching
snooding102910433snoo_ding
snooking133010583snoo_king
snooling93013473snoo_ling
snooping113811323snoo_ping
snooting92813203snoo_ting
snoozing18319083snoo_zing
snoozling19314343snoozling
socking143518603s__ocking
soochongs1583143s_oochongs
sooting82820963s_oo_ting
souchong1484513s_ouchong
soughing13259733s_oughing
southing122811823s_outhing
sploshing1544293sploshing
splotching1842863splotching
spoofing14228363spoo_fing
spooking15269803spoo_king
spooling113212563spoo_ling
spooning112811443spoo_ning
spooring113111463spoo_ring
squooshing2341993squooshing
stanching1538083stanching
starching1538593starching
stitching1547103stitching
stocking152912503s_tocking
stomaching1844313stomaching
stooging102810043stoo_ging
stooking132711143stoo_king
stooling93113133stoo_ling
stooping113012363stoo_ping
switching1835703switching
swooning12278203swoo_ning
swooping14338403swoo_ping
synching17227713s_ynching
toothing12278863_toothing
torching142510083_torching
touching143211343_touching
vouching17308233_vouching
whooshing1943213whooshing
wooshing1536683_wooshing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411376.75022020.9
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.24924650.4
 
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.