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 “spoliated” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
spoliated124691(None) 
spoliate1039241spoliate_
spoliates1138541spoliates
foliated1249912_foliated
solated83618022s_ol_ated
solvated12237442s_olvated
speciated14207542speciated
splinted11369252sp_linted
spoliator1144842spoliator
associated13114703associated
bloviated1573633bloviated
ciliated11510953_ciliated
collated113615063_collated
defoliated1545833defoliated
epilated11310753epil_ated
exfoliated2163393exfoliated
filiated12610083_filiated
floriated1347023floriated
foliaged1344673_foliaged
foliate10513533_foliate_
foliates11412753_foliates
isolated9410523isol_ated
opiated1039483__opiated
oppilated1444583oppilated
palliated1238503palliated
palmated132511003_palmated
palpated13249763_palpated
pileated112711133_pileated
plaited103713893_p_laited
plated95225773_p_l_ated
pleated103816633_p_leated
plicated13310643_p_licated
pointed103813983_po_inted
poleaxed1854823_poleaxed
policed123212233_poli_ced
polished1468433_polished
polite83625073_poli_te_
politer92417073_poli_ter
polkaed1435323_polka_ed
pollinated1345823_pollinated
polluted1135433_polluted
posited10511493_posi_ted
pulsated1136853_pulsated
salivated1337473s_alivated
saponated1245733sapo_nated
satiated9311603s_atiated
sealifted1344573sealifted
seriated92717023s_eriated
shoplifted1952093shoplifted
sibilated1246713sibilated
slated75028313s__l_ated
slitted83513313s__litted
solaced102911063s_ol_aced
solate64526073s_ol_ate_
solates73523853s_ol_ates
solicited1247973s_olicited
solvate102710213s_olvate_
solvates11249673s_olvates
sonicated1248453s_onicated
sopited104211063s_opi_ted
speciate12209583speciate_
speciates13229243speciates
spectated14236593spectated
spicated13309903sp_icated
spirited1148973spiri_ted
spirted103913073sp__irted
spited94820443sp__i_ted
spitted103912703sp__itted
splatted11356743sp_latted
splayed13357813sp_l_ayed
spliced124310593sp_li_ced
splined105013113sp_li_ned
splinter10329703sp_linter
splitter10348443sp_litter
spoilage11195373spoilage_
spoilages12184713spoilages
spoiled104811353spo_i_led
spoliating1366963spoliating
spoliation1248423spoliation
spoliators1244823spoliators
sported104015433spo__rted
sporulated1345263sporulated
spotlighted1851663spotlighted
spotted103713143spo__tted
spouted103412263spo__uted
sprinted113411163sp_rinted
stellated1046803stellated
striated93414153s_triated
sublated11311503subl_ated
sublimated1545873sublimated
sulcated11310373s_ulcated
sulfated1238833s_ulfated
supplicated1843733supplicated
uplifted1454423up_lifted
violated1237883viol_ated

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.436409841.7
2DLD Change Limit148641957.30020361.8
3Display Results95950.0303166.7
 (SQL Overall)178691957.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.