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

97 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
unspoiled1225556(None) 
unsoiled92412081uns_oiled
unspooled12254911unspooled
despoiled1344652despoiled
spoiled104811352__spoiled
unboiled112410372un_boiled
unbroiled1235802unbroiled
uncoiled112512682un_coiled
unfoiled12249722un_foiled
unoiled82415482un__oiled
unpiled102312742un_p_iled
unpoised1139182un_poised
unpolled1168942un_polled
unspilled1245092unspilled
unspoilt1044882unspoil_t
unspotted1244932unspotted
assoiled935023_assoiled
despoiler1243963despoiler
ensiled82611433ens__iled
ensouled935833ens_ouled
entoiled968283en_toiled
insouled936113ins_ouled
inspired1136273insp_ired
mispoised1446803mispoised
respooled1245593respooled
soiled73822473__s_oiled
speiled104412123__speiled
spiled94621993__sp_iled
spoiler93310683__spoiler
spooled104613523__spooled
subsoiled1245453subs_oiled
topsoiled1242643topsoiled
unapplied1443743unapplied
unassailed1142913unassailed
uncoined111813023un_coined
uncooled112710633un_cooled
undefiled1446113undefiled
unhailed12219963un_hailed
unjoined16248443un_joined
unmailed11229763un_mailed
unnailed9229443un_nailed
unpaired11208943un_paired
unpeeled11118533un_peeled
unpeopled1444533unpeopled
unpile81914323un_p_ile_
unpiles92112783un_p_iles
unpointed1237153un_pointed
unpoliced1445163un_policed
unposed10711903un_po_sed
unposted1159433un_posted
unpotted11108393un_potted
unpriced1338143un_priced
unprimed1337203un_primed
unprized2038513un_prized
unrolled9610413un_rolled
unsaddled1243983unsaddled
unsampled1444443unsampled
unscaled111410113uns_caled
unschooled1642733unschooled
unsealed91513623uns_ealed
unseized1838443uns_eized
unsettled1055213unsettled
unshelled1336563unshelled
unsized172510543uns__ized
unskilled1444603unskilled
unsliced1138093uns_liced
unsmoked1536013unsmo_ked
unsnarled1035743unsnarled
unsoaked1338853uns_oaked
unsold71410513uns_o_l_d
unsolid8138373uns_o_lid
unsolved1237833uns_olved
unsoothed1344253unsoothed
unsorted9312513uns_orted
unsoured9310063uns_oured
unsowed112511053uns_o_wed
unsphered1556103unsphered
unspilt938853unsp_il_t
unspoke1336573unspo_ke_
unspoken1454243unspo_ken
unspool945163unspool__
unspools1043693unspool_s
unsprayed1554363unsprayed
unstained1038683unstained
unsteeled1045753unsteeled
unstocked1645063unstocked
unstoned9311043unsto_ned
unstopped1444403unstopped
unstriped1246303unstriped
unsuited9310793uns_uited
unsullied1044543unsullied
unswollen1242623unswollen
unveiled1298163un_veiled
unvoiced14106303un_voiced
upboiled13194853u_pboiled
upcoiled13215183u_pcoiled
uppiled12216593u__ppiled

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 Limit148641976.86021667.8
3Display Results97970.0303233.3
 (SQL Overall)178691977.34324334.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.