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 “missteers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
missteers113591(None) 
missteer1037221missteer_
masseters1136282masseters
minsters103813922minst_ers
misesteems1442492misesteems
missileers1244192missileers
missteered1343552missteered
missteps12156142misst_eps
misters93927512mi_st_ers
bisters93922613bi_st_ers
diasters92913183diast_ers
diesters92513603diest_ers
disasters1039153disast_ers
disesteems1342883disesteems
dissevers1386863dissevers
fibsters13126413fibst_ers
hipsters13268793hipst_ers
hissers104112313hiss__ers
issuers746123_iss_uers
kiesters123310153kiest_ers
kissers114211293kiss__ers
listees73416673li_stee_s
listeners9147323li_steners
listers74026533li_st_ers
massagers1245513massagers
masseter1037063masseter_
masseurs1034923mass_eurs
masters94628923m_ast_ers
meisters103313843meist_ers
messieurs1142113messieurs
mestees94617753m_estee_s
mijnheers2141613mijnheers
milters93619093mi_lt_ers
ministers1139623minist_ers
minster93914323minst_er_
minstrels1145693minstrels
minters93822473mi_nt_ers
misalters1136913misalters
misavers1348063mi_savers
misdeeds12276813mi_sdeeds
misdeems13255653mi_sdeems
misdoers1137103mi_sdoers
misenters1139533misenters
misereres1148183misereres
misers85025703mi_s__ers
misesteem1344133misestee_m
misfeeds14315623mi_sfeeds
mishears1338323mi_shears
misinfers1445483misinfers
misinters1138183misinters
miskeeps1644163mi_skeeps
mislayers1445943mislayers
mislikers15317063mislikers
mismeets12297733mi_smeets
misnomers1346183misnomers
misorders1245883misorders
misrefers1445363misrefers
misseats104011683miss_eats
missels94614813miss__els
missends11368233miss_ends
misses85130873miss__e_s
missets94516573miss__ets
misshapers1743403misshapers
missies93423983miss_ie_s
missileer1145583missileer_
missilery1444553missilery
missiles103015083missile_s
missioners1245853missioners
missises103513693missise_s
missives133212843missive_s
misspeaks1743063misspeaks
misspells1343763misspells
misspends1443853misspends
misstamps1543373misstamps
misstart10410033misst_art
misstarts1145833misstarts
misstates11710633misstates
missteering1444453missteering
misstep11158463misst_e_p
misstops12176413misst_ops
misstyles1445023misstyles
missuses10309683missuse_s
mistakers15117083mistakers
mistends11419593mi_stends
mister84728563mi_st_er_
misterm114314513mi_st_erm
misterms123711353mi_sterms
mistier93418713mi_stier_
mistress10310703mi_stress
misusers10348083mi_susers
miterers10219683mi__terers
miters84328783mi__t_ers
mithers123516733mi__thers
mobsters12359063mobst_ers
moisteners1244783moisteners
monsters103314553monst_ers
mossers94116193moss__ers
muleteers1143673muleteers
munsters104010553munst_ers
musketeers1642213musketeers
mustees94614923m_ustee_s
musters94522513m_ust_ers
outsteers936033outsteers
piasters102912813piast_ers
pissers95014753piss__ers
sisters73721593si_st_ers
steers63820983___steers
tipsters10278513tipst_ers
visiters1137413visit_ers

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.1731032896.0
2DLD Change Limit1486411097.58019609.6
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.79922912.0
 
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.