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

53 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
mislights154466(None) 
mislight1447241mislight_
gaslights1463752gaslights
midnights1642682midnights
mislighted1743652mislighted
slights112810722__slights
alights113211433__alights
blights133110213__blights
daylights1743283daylights
delights1347333_delights
fanlights1643923fanlights
firelights1764013firelights
fistfights2052173fistfights
flights143310983__flights
gaslight1395343gaslight_
highlights1752393highlights
infights1545573_infights
insights1245493_insights
lights104519913___lights
limelights1652793limelights
lowlights1643653lowlights
midlists1137523midli_sts
midnight1544493midnight_
mights123516253m___ights
milligals1245033milligals
millimhos1642893millimhos
milliohms1643673milliohms
millwrights2051493millwrights
misaligns1244773misalig_ns
misfits12279663misfi__ts
mishits122513083mishi__ts
mislies92922283misli__es
mislighting1843413mislighting
mislikers15317063mislikers
mislikes143311833misli_kes
mislit83019693misli__t_
mislives132912153misli_ves
moonlights1642993moonlights
penlights1544203penlights
plights13299313__plights
relights1248053_relights
resights1246733res_ights
rushlights1761783rushlights
sidelights15153703sidelights
sights103818013__s_ights
skylights2042843skylights
sleights12275913__sleights
slight103416003__slight_
sunlights1344003sunlights
taillights1443343taillights
twilights1642533twilights
unsights1244623uns_ights
uplights14165053_uplights

Search took 7 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 Limit148641536.26623721.8
3Display Results53530.0134076.9
 (SQL Overall)178691536.71526610.7
 
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.