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

84 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
unspooled1225491(None) 
unspoiled12255561unspoiled
respooled1245592respooled
spooled104613522__spooled
uncooled112710632un_cooled
unpolled1168942un_polled
unschooled1642732unschooled
unsoiled92412082uns_oiled
unspilled1245092unspilled
unspool945162unspool__
unspools1043692unspool_s
unspotted1244932unspotted
carpooled1445073carpooled
despoiled1344653despoiled
ensouled935833ens_ouled
insouled936113ins_ouled
pooled94619813___pooled
shooled115212663__shooled
snooled84513943__snooled
spoiled104811353__spoiled
spoofed13399103__spoofed
spooked144510473__spooked
spooler93711383__spooler
spooned103412443__spooned
spoored104411293__spoored
stooled84313893__stooled
unblooded1343843unblooded
unboiled112410373un_boiled
unbooted1188773un_booted
unbroiled1235803unbroiled
uncoiled112512683un_coiled
uncooked15269113un_cooked
unfoiled12249723un_foiled
ungroomed1343993ungroomed
unhooded13277873un_hooded
unhooked16286743un_hooked
unloosed9117523un_loosed
unmoored1137333un_moored
unoiled82415483un__oiled
unopposed1443133unopposed
unpeeled11118533un_peeled
unpeopled1444533unpeopled
unpiled102312743un_p_iled
unplowed1436353un_plowed
unpoised1139183un_poised
unposed10711903un_p_osed
unposted1159433un_posted
unpotted11108393un_potted
unprobed1366973un_probed
unproved1457533un_proved
unrolled9610413un_rolled
unroofed12106773un_roofed
unrooted9810513un_rooted
unsaddled1243983unsaddled
unsampled1444443unsampled
unscaled111410113uns_caled
unsealed91513623uns_ealed
unsettled1055213unsettled
unshelled1336573unshelled
unskilled1444603unskilled
unsmoked1536013uns_moked
unsmoothed1642003unsmoothed
unsnarled1035743unsnarled
unsoaked1338853uns_oaked
unsold71410513uns__ol_d
unsolid8138373uns__olid
unsolved1237833uns_olved
unsoothed1344253unsoothed
unsorted9312513uns_orted
unsoured9310063uns_oured
unsowed112511053uns__owed
unsphered1556103unsphered
unspoilt1044883unspoil_t
unspoke1336573unsp_oke_
unspoken1454243unsp_oken
unspooling1343853unspooling
unsprayed1554363unsprayed
unsteeled1045763unsteeled
unstocked1645063unstocked
unstoned9311043uns_toned
unstopped1444403unstopped
unswollen1242623unswollen
unwooded13207443un_wooded
unwooed11229773un_woo_ed

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 Limit148641846.92321470.6
3Display Results84840.0461826.1
 (SQL Overall)178691847.40524131.1
 
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.