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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
scootched176396(None) 
scooched16206681scoo_ched
scootches1635001scootches
scotched16187931sc_otched
scrootched1842331scrootched
crotched16428592_crotched
scooches15188412scoo_ches
scootch1434462scootch__
scooted103612282scoot__ed
scorched16187192sc_orched
scotches15179472sc_otches
scratched1735392scratched
scrooched1763842scrooched
scrootches1743322scrootches
scutched16186892sc_utched
smooched16185982smoo_ched
smoothed14236472smoot_hed
soothed113712742s_oot_hed
splotched1742822splotched
blotched1635653_blotched
botched153611903__botched
clothed134010283_clot_hed
clutched16356033_clutched
coached153313843_c_oached
cooches143515833_coo_ches
couched154115793_c_ouched
crotches153411303_crotches
crotchet152711993_crotchet
crouched16359143_crouched
crutched16307463_crutched
hootches1656973_hootches
hotched163610923__hotched
mooched153910533_moo_ched
notched134210303__notched
pooched152810083_poo_ched
scathed134012643sc_at_hed
schatchen1943853schatchen
sconced12359173sc_onc_ed
scooch13228123scoo_ch__
scooped124611743scoo__ped
scootching1843363scootching
scooter93312873scoot__er
scorcher15196783sc_orcher
scorches15189143sc_orches
scotch13207523sc_otch__
scouted104112033scout__ed
scouther1356943scout_her
scraiched1744203scraiched
scratcher1635443scratcher
scratches1647323scratches
screeched17114333screeched
scrooches1645703scrooches
scrootch1542813scrootch__
scrunched1744033scrunched
scultches1664293scultches
scutcher15176963sc_utcher
scutches15168883sc_utches
scythed16385303sc_yt_hed
sketched1835393s_ketched
slouched14206743s_louched
smoocher15205503smoo_cher
smooches15217263smoo_ches
smooshed14185993smoo_shed
smoothen13204963smoot_hen
smoother13196673smoot_her
smoothes13218543smoot_hes
smutched16165923s_mutched
snatched14157633s_natched
snitched14166863s_nitched
snooted84213283snoot__ed
sooted73922593s_oot__ed
soothe94214853s_oot_he_
soother104215043s_oot_her
soothes103917113s_oot_hes
southed114313993s_out_hed
splotches1643913splotches
stitched14148203s_titched
stomached1794013stomached
stretched1546213stretched
switched17157133s_witched
swooshed15174273swoo_shed
toothed113310243_toot_hed

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641828.09318366.6
3Display Results82820.0631301.6
 (SQL Overall)178691828.31221498.0
 
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.