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

82 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
spotlit94730(None) 
split75729012sp__lit
spoilt85016592spoil_t
spotlight1543712spotlight
moonlit9229333moonlit
petit74332653_pet_it
polio75722553_po_lio
polis74731163_po_lis
polite83625073_po_lite
polity113015863_po_lity
pollist9816603_pollist
poplin10413483_poplin
posit75833333_po_sit
potent84223353_potent
potlike13910123_potlike
potline91015233_potline
potpie103412433_potpie
potsie83916033_potsie
poult76928873_poul_t
rootlet73015733rootlet
scotia8310803scot_ia
scottie937463scottie
shitlist1148723shitlist
shoplift1645193shoplift
shortlist1246683shortlist
shott85332193shot__t
skylit1338283s_kylit
slit46250103s___lit
smolt74824163smo_l_t
sobeit8315363s_obeit
soffit1237883s_offit
soli46637013s_o_li_
solid65025083s_o_lid
sootily101810523sootily
spait75631603sp__ait
spathic1437543spathic
spelt75430193sp_el_t
spilt75532223sp_il_t
spirit83519923sp_irit
spit65545083sp___it
splat76129343sp__lat
splint85223283sp__lint
splits85416413sp__lits
spoil75818653spo__il
spoiled104811353spoiled
spoiler93310683spoiler
spoiling112911553spoiling
spoils84614533spoil_s
spoliate1039243spo_liate
spongin1036373spongin
spool75219043spool__
spooled104613523spooled
spooler93711383spooler
spooling113212563spooling
spools85115913spool_s
sporoid102310733sporoid
sport75935983spo__rt
sportif1238803sportif
sportily1337733sportily
spot65540693spo___t
spotless1037043spotless
spotlights1642593spotlights
spots74424113spot__s
spotted103713143spotted
spotter94514883spotter
spottier10207313spottier
spottiest11177693spottiest
spottily1335153spottily
spotting112812093spotting
spotty11448583spot_ty
spout75029633spo__ut
sprit76736403sp__rit
sputnik1372273sputnik
starlit71512913starlit
stilt54831983s__tilt
stolid74213183sto_lid
stoolie739723stoolie
stotin63215063stot_in
stott56929793stot__t
sunlit61516103s_unlit
uplit76020803up__lit
uptilt8410803up_tilt

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 Filter1786911340270.403443402.0
2DLD Change Limit134027826.89319443.9
3Display Results82820.0302733.3
 (SQL Overall)178691827.32624391.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.