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

113 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
squashy223384(None) 
squash1846831squash_
squishy2244021squishy
quash174512162_quash_
slushy12417222slu_shy
splashy1543552splashy
squabby2343282squabby
squally1937672squally
squashed21215982squashed
squasher20185782squasher
squashes20207802squashes
squashily2442792squashily
squatly1946432squatly
squatty1964822squatty
squish1838572squish_
squooshy2381272squooshy
squush1833992squush_
aquas142412613aquas__
ashy107717353___ashy
brashy145210593_brashy
brushy14468263bru_shy
bushy135416683_bu_shy
cushy134412323_cu_shy
dashy125612383__dashy
equably2136183equably
equally1936873equally
flashy15498173_flashy
gushy125213123_gu_shy
mashy136016503__mashy
mushy135316633_mu_shy
musquash2241603musquash_
oquassa1642063oquassa
plashy14448873_plashy
plushy14406973plu_shy
pushy134614353_pu_shy
quacky24376963_quacky
quaggy2084683_quaggy
quaky214310743_qua_ky
qualmy20285803_qualmy
quarry1837473_quarry
quasar1536833_quasar
quashed20207973_quashed
quasher19198623_quasher
quashes192110973_quashes
quasi144015023_quas_i
quass144413763_quas_s
quay164618353_qua__y
queasy1855173_queas_y
qursh174110843_qursh_
rushy115414813_ru_shy
sash77235303s__ash_
sashay1238363s__ashay
sassy85813813s__assy
saughy13507463sau_ghy
shush113812543shu_sh_
skuas95611733skuas__
slash84719683s_lash_
sloshy12366623s_loshy
slush85316573slu_sh_
smash104814433s_mash_
smush104410583smu_sh_
smutchy17193153smutchy
snash84815673s_nash_
splash1168823splash_
squab163810733squa__b
squabs17429323squa_bs
squad155110793squa__d
squads164410293squa_ds
squalid1737053squalid
squall1538003squa_ll
squalls1647313squalls
squalor1644423squalor
squama1736533squa_ma
squamae1845723squamae
square154513363squa_re
squared173610563squared
squarely2045353squarely
squarer163410663squarer
squares163714463squares
squarish2047323squarish_
squarishly2542703squarishly
squark19438113squa_rk
squarks20417183squarks
squashers21184983squashers
squashier2143913squashier
squashing2234703squashing
squat143720143squa__t
squats153712963squa_ts
squaw17368983squa__w
squawk22385373squa_wk
squawks23294883squawks
squaws18438783squa_ws
squeaky2343083squeaky
squelchy2591983squelchy
squiffy2542573squiffy
squinny19274223squinny
squinty19287063squinty
squirmy21374293squirmy
squished21186393squished
squishes20198393squishes
squoosh1962843squoosh_
squushed21193703squushed
squushes20194673squushes
stash84916973s_tash_
suably112814533s_uably
suasory1046043s_uasory
sudsy95010683s_uds_y
sushi8310493s_u_shi
swash116316753s_wash_
swishy15365843s_wishy
trashy12509053_trashy
tushy114212993_tu_shy
washy145911843__washy

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271137.29618369.9
3Display Results1131130.0333424.2
 (SQL Overall)1786911137.46923924.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.