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

192 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
subsale931054(None) 
subsales10310121subsales
subscale1247601subscale
bubale104014622bub_ale
subbase1139322subbase
subfile122010502subfile
sublate9315362sublate
subrace11313002subrace
subrule939642subrule
subsample1542522subsample
subscales1347342subscales
subsere9311442subsere
subside10410452subside
subsite9412872subsite
subspace1445682subspace
substage11117182substage
substate101711092substate
subsume1146712subsume
subtile91912622subtile
subtle82113432sub_tle
abusable1236373abusable
ambsace1355963ambsace
aubade939223aub_ade
bale66353843__b_ale
bubal94218213bub_al_
bubales113513343bub_ales
bubals103513843bub_als
bubble94016593bub_ble
bursae84515603bursa_e
bursal84414823bursal_
bursate94111203bursate
bustle84015483bu_stle
cubage1178273cub_age
cubicle1337003cubicle
fusile94313493fu_sile
gunwale1134733gunwale
hustle93113993hu_stle
jubile152910263jub_ile
justle133211583ju_stle
muscle10310973mu_scle
nubble103813713nub_ble
nubile83212713nub_ile
outsole71013433outsole
presale9416353presale
pulsate9510233pulsate
quale143617853qu__ale
resale64025543_resale
rubace10310173rub_ace
rubasse934903rubasse
rubble104315673rub_ble
ruble74521253rub__le
rustle63615413ru_stle
sabal75422483sab_al_
sabals84618863sab_als
sable74732163sab__le
sale44959703___sale
sausage847193sausage
scale74629143s__cale
seisable10311373seisable
sensate7311893sensate
sesame8311013s_esame
sessile739523sessile
shale85332833s__hale
sisal54217733s_isal_
sisals63013573s_isals
spale74929213s__pale
stale55637103s__tale
stubble1136843stub_ble
suable83920553su_able
suasive1037853suasive
suave83519873su__ave
suba64926603sub_a__
subah106015213sub_a_h
subahs114512383sub_ahs
subalar9118073sub_alar
subarea939403sub_area
subas74724073sub_a_s
subbases1239063subbases
subbass1138033subbass
subcaste1287853subcaste
subcause1265823subcause
subcell1146753subcell
subclan1147173subclan
subcode1237163subcode
subcult1149603subcult
subdealer1245223subdealer
subduable1444143subduable
subdual10126713subdual_
subduals1156293subduals
subduce12106983subduce
subdue9128493sub_due
subfiles131710723subfiles
subframe1546333subframe
subgoal1046323subgoal_
subgoals1145553subgoals
subgrade1246053subgrade
sublated11311503sublated
sublates10315003sublates
sublease1038383sublease
sublet82827243sub__let
sublime11310363sublime
subline9316893subline
subnasal1044183subnasal_
suboral92011993suboral_
suboval12216723suboval_
subovate1347333subovate
subpanel1246073subpanel
subpar1048663subpa_r
subpart11311123subpart
subphase1555603subphase
subraces12313033subraces
subrules1039723subrules
subs66037123subs___
subsampled1751683subsampled
subsamples1652423subsamples
subsea82610193subs_ea
subsect112611843subsect
subsense1046963subsense
subseres10312423subseres
subserve1346473subserve
subset83122583subs_et
subsets92813103subsets
subshaft1645183subshaft
subshell1344883subshell
subsided1257663subsided
subsider1138243subsider
subsides11410823subsides
subsidy1345973subsidy
subsist9311573subsist
subsites10312783subsites
subskill1444233subskill
subsoil967293subsoil
subsoiled1245453subsoiled
subsoiler1145323subsoiler
subsoils1076653subsoils
subsolar1045113subsolar
subspaces1545673subspaces
substages12127353substages
substance1346753substance
substates111410333substates
substrate11178793substrate
subsumable1652613subsumable
subsumed1344943subsumed
subsumes1246923subsumes
subtask1335713subtask
subtaxa1644483subtaxa
subtiler10208573subtiler
subtitle1046603subtitle
subtler92910843sub_tler
subtly11249263sub_tly
subtone9310343subtone
subtype1444203subtype
subulate10312743subulate
subvene1238493subvene
subway1447073subwa_y
subwayed1753723subwayed
subways1536163subways
subzone1846993subzone
suckle124015963su_ckle
sucrase9310343sucrase
suitable10310893suitable
sulcal8311273sulcal_
sulcate9314423sulcate
sulfate10311653sulfate
sullage859913sullage
summable1436903summable
summae103911013summa_e
summate113611663summate
sundae7312873sunda_e
sunscald11113273sunscald
sunshade1244353sunshade
supersale11411323supersale
supple10410203su_pple
sural55931263su_ral_
surbase939793surbase
surfable1338443surfable
surface1238653surface
surname937603surname
swale85221593s__wale
tubae74716643tub_a_e
tubal75517203tub_al_
tubate82813173tub_ate
tubbable1134683tubbable
tubule839853tub_ule
tussal6288323tussal_
tussle637143tu_ssle
unbale83616403_unbale
unsafe9310693_unsafe
upscale11136323_upscale
ursae55214453_ursa_e
usable84012553_u_sable
usage6410213_u_sage

Search took 7 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.420425454.8
2DLD Change Limit1340271926.45320769.7
3Display Results1921920.0802400.0
 (SQL Overall)1786911926.95325699.8
 
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.