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

55 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
misspends144385(None) 
missends11368231miss_ends
misspend1345241misspend_
dispends12308532di_spends
mispens11311072mi_spen_s
missend104411372miss_end_
missounds1243532missounds
misspeaks1743062misspeaks
misspells1343762misspells
misspent1259172misspen_t
mistends11419592mi_stends
airspeeds1242513airspeeds
dispend11289413di_spend_
dissents93411863diss_ents
distends10339823di_stends
fishponds1852513fishponds
fissipeds1542423fissipe_ds
impends12376803_i_mpends
millponds1443503millponds
minuends1143893mi_nuends
misagents1246793misagents
misbinds1345163mi_sbinds
misbrands1445153misbrands
misdeeds12276813mi_sdeeds
misevents1456003misevents
misfeeds14315623mi_sfeeds
misfields15223653misfields
misleads11358543mi_sleads
mispen10312173mi_spen__
mispleads1444203mispleads
misreads11268923mi_sreads
misseats104011683miss_eats
missed94423603miss_e_d_
missels94614813miss_e_ls
missense1037963miss_ense
missenses1148033miss_enses
missent94318713miss_en_t
misses85130873miss_e__s
missets94516573miss_e_ts
missies93423983missie__s
missions10311903mission_s
missound1145113missound_
misspaces1546513misspaces
misspeak1643493misspe_ak
misspell1244303misspe_ll
misspelt1247273misspe_lt
misspending1743653misspending
missteers1135913missteers
missteps12156143misste_ps
mistend103812523mi_stend_
outspends1294123outspends
resuspends1341483resuspends
spends94714473___spends
suspends1145143_suspends
vilipends1542073vilipends

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.423422437.4
2DLD Change Limit148641556.86021667.8
3Display Results55550.0301833.3
 (SQL Overall)178691557.31324434.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.