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

89 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
unspotted124493(None) 
unpotted11108391un_potted
respotted1235952respotted
spotted103713142__spotted
undotted1048522un_dotted
unknotted1443612unknotted
unpitted1148622un_pitted
unposted1159432un_posted
unsoothed1344252unsoothed
unsorted9312512uns_orted
unspoiled12255562unspoiled
unspooled12254912unspooled
besotted1135843bes_otted
disported13310303disported
inputted1134663in_putted
insetted9249023ins_etted
inspected1445403inspected
knotted12357223kn__otted
pinspotter1452123pinspotter
potted94624013___potted
repotted1139283_repotted
shotted113912403__shotted
slotted84613883__slotted
sotted74121403__s_otted
spatted104014143__spatted
spitted103912703__spitted
sported104015433__sported
spotter94514883__spotter
spouted103412263__spouted
stotted83511423__stotted
swotted11398713__swotted
unabetted1244993unabetted
unaborted1245733unaborted
unadopted1344563unadopted
unbitted1138213un_bitted
unbolted1179323un_bolted
unbooted1188773un_booted
unbottled1244153un_bottled
unclothed1545433unclothed
uncoated11314963un_coated
unfitted1238163un_fitted
ungotten944533un_gotten
unhatted1238183un_hatted
unknitted1443703unknitted
unletted9310313un_letted
unmatted1138293un_matted
unnoted8311363un_no_ted
unparted11310823un_parted
unpitied1138793un_pitied
unpointed1237153un_pointed
unpoised1139183un_poised
unpolled1168943un_polled
unposed10711903un_po_sed
unquoted1836533unquo_ted
unreported1344073unreported
unrooted9810513un_rooted
unsalted9510923uns_alted
unsated83419933uns__ated
unscathed1535313unscathed
unscented1237513unscented
unseated91317683uns_eated
unsettled1055213unsettled
unshifted16124943unshifted
unshirted13105953unshirted
unsifted12128773uns_ifted
unsighted1455433unsighted
unsmoked1536013unsmo_ked
unsmoothed1642003unsmoothed
unsoaked1338853uns_oaked
unsoiled92412083uns_oiled
unsolved1237833uns_olved
unsoured9310063uns_oured
unsowed112511053uns_o_wed
unsphered1556103unsphered
unspilled1245093unspilled
unspoke1336573unspo_ke_
unspoken1454243unspo_ken
unsprayed1554363unsprayed
unstated91615813uns_tated
unstinted1038563unstinted
unstocked1645063unstocked
unstoned9311043unsto_ned
unstopped1444403unstopped
unsuited9310793uns_uited
unsupported1651353unsupported
unswathed1634543unswathed
unwetted1238123un_wetted
unwitted1237543un_witted
unwonted12248643un_wonted

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.1561145455.1
2DLD Change Limit148641896.86021667.8
3Display Results89890.0302966.7
 (SQL Overall)178691897.04625360.6
 
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.