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

112 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
spoliates113854(None) 
spoliate1039241spoliate_
spoliated1246911spoliated
foliates11412752_foliates
solates73523852s_ol_ates
solvates11249672s_olvates
speciates13229232speciates
spoilages12184712spoilages
spoliator1144842spoliator
spoliators1244822spoliators
apholates1449683aphol_ates
aplites9314933ap_li_tes
apostates1149163apostates
associates12115883associates
bloviates1484543bloviates
cholates132414763chol_ates
ciliates10413453_ciliates
collates103019143_collates
defoliates1446333defoliates
epilates10313503epil_ates
exfoliates2063703exfoliates
filiates11412663_filiates
folates103218453_fol_ates
foliages1247623_foliages
foliate10513533_foliate_
foliated1249913_foliated
goliaths1244223_goliaths
hoplites13310543hopli_tes
iolites73819483_ioli_tes
isolates8613513isol_ates
oleates7417833__oleates
oolites72817843_ooli_tes
opiates9312143__opiates
oppilates1345453oppilates
palates93624933_pal_ates
palliates11311033palliates
palpates122613063_palpates
pelites93821993_peli_tes
plates85432243_p_l_ates
podites103014733_podi_tes
pointes93216753_po_intes
poleaxes1767273_poleaxes
polices113118053_poli_ces
policies122415663_policies
polies84034583_poli__es
polishes13711783_polishes
polite83625073_poli_te_
politer92417073_poli_ter
politest10312943_poli_test
polities102722343_polities
pollinates1247303_pollinates
pollutes1037613_pollutes
psoriases1144863psoriases
pulsates1048813_pulsates
salivates1239293s_alivates
saponites1139943saponi_tes
saprolites1247053saproli_tes
satiates8314633s_atiates
scapolites1455693scapoli_tes
scolices1238733scoli_ces
scolioses1155613scolioses
sepiolites1246013sepioli_tes
seriates82620673s_eriates
sibilates1148443sibilates
silicates11311523s_ilicates
slates64934063s__l_ates
soilages9189673s_oilages
solaces93116133s_ol_aces
solate64526073s_ol_ate_
solated83618023s_ol_ated
solutes73515263s_ol_utes
solvate102710213s_olvate_
solvated12237443s_olvated
somites94219123s_omi_tes
sonicates11410383s_onicates
sopites93817173s_opi_tes
sorbates10311103s_orbates
sorites73825243s_ori_tes
soulmates1147073soulmates
spates85028173sp___ates
speciate12209583speciate_
speciated14207543speciated
spectates13228813spectates
spillages1256083spillages
spites84127333sp__i_tes
splakes1349673sp_l_akes
splats84817303sp_l_at_s
splices113914383sp_li_ces
splines94718893sp_li_nes
splinted11369253sp_linted
splinter10329703sp_linter
splinters11277923sp_linters
splints94511743sp_lint_s
splits85416413sp_li_t_s
splitter10348443sp_litter
splitters11307323sp_litters
spoilage11195373spoilage_
spoliating1366963spoliating
spoliation1248423spoliation
spoliations1347693spoliations
sporulates1246483sporulates
sprites94220333sp_ri_tes
stomates10313343sto_mates
striates83417083s_triates
stylites11168693styli_tes
sublates10315003subl_ates
sublimates1447173sublimates
sulfates11310793s_ulfates
supplicates1744133supplicates
toluates8138903_toluates
violates11311193viol_ates
zeolites1738383zeoli_tes

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.453394461.4
2DLD Change Limit1486411127.47019898.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.96922423.3
 
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.