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

90 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
scrooches164570(None) 
scooches15188411sc_ooches
scrooched1763841scrooched
scrootches1743321scrootches
brooches15288192_brooches
cooches143515832_c_ooches
crotches153411292_crotches
crouches153711282_crouches
scooched16206682sc_ooched
scootches1635002scootches
scorches15189142sc_orches
scotches15179472sc_otches
scratches1647312scratches
screeches1695642screeches
scrooch1444952scrooch__
scrooges1137162scroo_ges
scrootched1842332scrootched
scrunches1635402scrunches
smooches15217262s_mooches
soroches1338802sor_oches
barouches1644973barouches
brioches15227253_brioches
broaches153211623_broaches
caroaches1637793caroaches
caroches15710693_caroches
carroches1665893carroches
cloches144113713_c_loches
coaches144018693_c_oaches
conches144019813_c_onches
couches144020463_c_ouches
cranches153114543_cranches
cratches153012543_cratches
creches14313093_cr_eches
crochet143616663_cr_ochet
crochets15359833_cr_ochets
crotched16428593_crotched
crotchet152711993_crotchet
crotchets16396293_crotchets
crouched16359143_crouched
crunches153711353_crunches
crutches15359583_crutches
encroaches1743083encroaches
grouches14328213_grouches
hooches153812523__hooches
mooches143714453__mooches
pooches143214163__pooches
roaches123616213__roaches
rotches123515703__rotches
rouches124217893__rouches
sconces113811453sc_onc_es
scooch13228123sc_ooch__
scootched1763963scootched
scorched16187193sc_orched
scorcher15196783sc_orcher
scorchers16145513sc_orchers
scotched16187933sc_otched
scraiched1744203scraiched
scraichs1543993scraich_s
scratched1735383scratched
scratcher1635433scratcher
scratchers1744283scratchers
screeched17114333screeched
screecher16144473screecher
screechers17143673screechers
scrooching1843323scrooching
scrooge1037173scroo_ge_
scrooped1356403scroo_ped
scroops11288243scroo__ps
scrootch1542813scrootch__
scrouges1136683scr_ouges
scrounges1243923scrounges
scrunched1744033scrunched
scrunchies1744343scrunchies
sculches15176273sc_ulches
scultches1664293scultches
scutches15168883sc_utches
slouches13208073s_louches
smooched16185983s_mooched
smoocher15205503s_moocher
smoochers16184833s_moochers
smooshes13206863s_mooshes
smoothes13218533s_moothes
soothes103917103s__oothes
soroche1237183sor_oche_
splotches1643913splotches
squooshes2142543squooshes
stretches1438283stretches
strophes13310593str_ophes
swooshes14185123s_wooshes
troches123715343_tr_oches

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.1561145455.1
2DLD Change Limit148641906.86021667.8
3Display Results90900.0461956.5
 (SQL Overall)178691907.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.