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

168 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
soluble96610(None) 
solubles1065891solubles
solubly1255281solubly
voluble1244501voluble
double94013992do_uble
insoluble1144242insoluble
isolable1038792isolable
resoluble1144142resoluble
rouble83913312ro_uble
salable91415462salable
solute64016662solu_te
solvable1337472solvable
sowable121610752sowable
toluole736112toluole
volubly1543552volubly
alible8311973_alible
bauble103813213_bauble
bobble94115143bo_bble
boilable1237793boilable
boucle103712783bo_ucle
boule74828043bo_u_le
boulle84614613bo_ulle
cobble123615263co_bble
coble94823173co__ble
codable12311663codable
columel1136273columel
colure8314163colu_re
couple104415963co_uple
dissoluble1353173dissoluble
doable93115243do_able
doubled11289953do_ubled
doubler103110083do_ubler
doubles103113353do_ubles
doublet103914033do_ublet
doubly12328963do_ubly
dowable13189453dowable
foible11410383fo_ible
foilable1338063foilable
foldable1437133foldable
gelable101710733gelable
globule1034383globule
gobble113512983go_bble
hobble133913433ho_bble
holdable1437073holdable
insolubles1253013insolubles
insolubly1443653insolubly
joule124918203jo_u_le
lobule82910063lobu_le
locule83412033locu_le
losable91910953losable
lovable12179553lovable
lube64731563__lub_e
module93011033modu_le
moldable1337103moldable
movable14189433movable
nobble103814313no_bble
noble74420993no__ble
nodule7309803nodu_le
nonuple946153nonuple
notable92114903notable
oscule838193oscu_le
ovule839493_ovu_le
pilule8411123pilu_le
pokable15209503pokable
posable112212783posable
potable112115363potable
roble75223023ro__ble
ropable111611333ropable
roubles93413513ro_ubles
rowable121510303rowable
ruble74521253__ruble
rulable9310533rulable
sable74732163s__able
sailable10310563sailable
salably121610743salably
saleable10312023saleable
salute64418023salu_te
salvable1338403salvable
savable121711863savable
sayable121411613sayable
scabble13168653scabble
scalable121710233scalable
scruple1137193scruple
scumble1337013scumble
sealable101512693sealable
seeable91113943seeable
sellable101711823sellable
selle54428313sel__le
sewable121911173sewable
shamble14149263shamble
shlub105411743shlub__
shlubs11386733shlub_s
showable1636583showable
silicle937753silicle
sizable1839893sizable
skiable1338883skiable
slub65428033s_lub__
slubbed12339283s_lubbed
slubber113010763s_lubber
slubs74719533s_lub_s
sludge84811943s_ludge
slue45332193s_lu__e
sluice849513s_luice
smokable1636223smokable
sociable1239503sociable
socle7419573so__cle
soilure736233soilu_re
solace83415823sol_ace
solate64526073sol_ate
sole46053673so___le
solely93714213sol_ely
solfege1144223solfege
solgel737963solgel_
solidly1137353solidly
solubilise1253393solubilise
solubilize2153553solubilize
solum74717613solu__m
solums85211333solu_ms
solunar735283solunar
solus54726983solu__s
solutes73515263solutes
solvate102710213solvate
solve85618943sol__ve
sombre10729473so_mbre
sorbable1239303sorbable
sortable10312483sortable
soubise9118793so_ubise
souffle13306803souffle
soul46435713so_u_l_
souled75419823so_u_led
souls55127363so_u_ls
source8410673so_urce
sourly93612213so_urly
souse56530773so_u_se
splurge1044763splurge
spoilable1345163spoilable
sporule937273sporu_le
stable83921643s_table
stonable1039843stonable
storable10310733storable
stowable1337613stowable
stubble1136843stubble
stumble1147553stumble
suable83920553s_uable
sublet82827243s__ublet
subtle82113433s__ubtle
syllable13177773syllable
toluate7159343toluate
toluene736463toluene
toluide835263toluide
toluol636903toluol_
toluoles835513toluoles
toluols735823toluols
toluyl933443toluyl_
toluyls1032833toluyls
totable92313363totable
tousle64514653to_usle
touzle15429003to_uzle
towable121910113towable
trouble957713trouble
valuable1336863valuable
violable1337543violable
vocable14189673vocable
volume11358273volu_me
volute93912763volu_te
votable122111373votable
wobble133212313wo_bble
zonule1577483zonu_le

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 Limit1340271686.28321331.7
3Display Results1681680.0602800.0
 (SQL Overall)1786911686.76326421.9
 
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.