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

133 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
saccule113674(None) 
saccules1237031saccules
sacculi1145041sacculi
accuse103411032_accuse
bascule1136572bascule
macule104115272ma_cule
saccade12107032saccade
saccate111311762saccate
saccular1246892saccular
sacculate1349022sacculate
sacculus1244812sacculus
sacque17107112sacqu_e
spicule11269932spicule
accede1138303_accede
accrue1035823_accrue
accused12368423_accused
accuser11347933_accuser
accuses114112193_accuses
acicula11228133_acicula
aciculae12267703_aciculae
aculei839793_a_culei
acute74720363_a_cute
ampule10710613_ampule
baccae12119703bacc_ae
baccate131011263baccate
bacula103112673ba_cula
barbule1137943barbule
bascules1236683bascules
cackle143416923ca_ckle
calculi1146563calculi
capsule1137343capsule
ductule1065503ductule
facile112514883fa_cile
facture12108933facture
facula112912233fa_cula
faculae123210353fa_culae
fascicule1643063fascicule
floccule1542813floccule
hachure1545723hachure
hackle154916813ha_ckle
lacune8169673la_cune
locule83412033_locule
macchie1647193macchie
mackle143716433ma_ckle
macle96127003ma_c_le
macula103013673ma_cula
maculae113412863ma_culae
maculed123510053ma_culed
macules114015133ma_cules
nacelle938153nacelle
noctule936083noctule
occult1038433_occult
oscule838193_oscule
papule102212133pa_pule
rackle123917293ra_ckle
reaccuse1245043reaccuse
sable74732163sa__ble
sacbut10811943sacbu_t
sacbuts1166473sacbuts
saccades13137253saccades
sacculated1546623sacculated
sackful1645353sackful_
sackfuls1744163sackfuls
saclike131210123saclike
sacques18106863sacques
sacral83414413sacral_
sacrals93311793sacrals
sacrum103910143sacru_m
sacrums11388043sacrums
saddle83915493sa_ddle
safrole1037253safrole
saice75424053saic__e
salable91415463salable
sale44959703sa___le
salute64418023sa_lute
sambuke1544203sambuke
sample104215013sa_mple
sanicle91210263sanicle
satchel123310303satchel
sauce75121653sa__uce
saucily1237913saucily
saul45836523sa__ul_
sauls55128123sa__uls
sault55834963sa__ult
saute55028083sa__ute
savable121711863savable
sayable121411613sayable
scabble13168653scabble
scale74629143s__cale
scapula1136343scapula
scapulae1255433scapulae
schul102510413s_chul_
schuln11256233s_chuln
schuls11299853s_chuls
scouse84113633s_couse
scruple1137193s_cruple
sculk115112463s__culk
scull75315763s__cull
sculp95314843s__culp
scute75520943s__cute
seclude1035233seclude
sectile9311973sectile
secure8513533s_ecure
shackle16409543shackle
sickle124418323s_ickle
soccage1236283soccage
socle7419573s_oc_le
spackle15369573spackle
spansule1043623spansule
speckle15297553speckle
specula11187413specula
spicula11259293spicula
spiculae12218603spiculae
spicules12219803spicules
spinule9299993spinule
sporule937273sporule
stickle132410973stickle
stipule936723stipule
subcult1149603subcult
subrule939643subrule
succuba1343443succuba
succubae1443083succubae
succubi1342883succubi
succulent1344543succulent
succumb1543283succumb
succuss1134993succuss
suckle124015963s_uckle
tackle123815733ta_ckle
tactile9310613tactile
vaccine1437323vaccine
vacuole1245373vacuole
valvule1343663valvule
vascula1245853vascula

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.406440125.6
2DLD Change Limit1340271337.26318453.4
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.71523161.5
 
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.