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

92 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
misorder114728(None) 
disorder1038131disorder
misorders1245881misorders
disorders1146962disorders
misordered1443792misordered
misworded1644232misworded
absorber1254313absorber
absurder11134363absurder
accorder1395253accorder
adsorber1143503adsorber
assorter866673assorter
birder94915493bi__rder
border94419973__border
corder94322883__corder
disarmer1138033disarmer
discarder1346753discarder
discorded1438133discorded
disordered1344323disordered
disorderly1552623disorderly
disrober1147623disrober
distorter1048403distorter
divorcer1444033divorcer
emborder1345083emborder
girder84312063gi__rder
importer12308913importer
isomer8310153_iso_mer
mesoderm1344493meso_derm
milder93818453mi__lder
milord999573milord__
milords10117853milord_s
minder94822503mi__nder
minored10310103minor_ed
mirier83918363mi__rier
mirker123712693mi__rker
misadded1335753misadded
misalter1038343misalter
misaver1249813mis_aver
miscode12310413miscode_
miscoded1437983miscoded
miscodes13310423miscodes
misdoer1048633mis_doer
misdrew1335833misdr_ew
misenter10310833misenter
miser75430403mis___er
miserere1049273miser_ere
miseries10320403miseries
misformed1745243misformed
misgrade1247503misgrade_
misgraded1446233misgraded
misgrades1347363misgrades
misgrew1335523misgr_ew
misguider13174343misguider
misinfer1345323misinfer
misinter1038833misinter
misjoinder2052703misjoinder
mislayer1337503mislayer
misleader1246503misleader
misliker14319573misliker
mismade12129353mismade_
misnomer1247143misnomer
misordering1544033misordering
misorient11510893misorient
misprizer2245343misprizer
misrefer1346103misrefer
misrender1286293misrender
missorted1247033missorted
missteer1037223missteer
mistaker14109333mistaker
mister84728563mis__ter
mistier93418713mis_tier
misuser93210443mis_user
misword1338413misword__
miswords1446603misword_s
miterer92511333miter_er
molder93819273m__older
moorier93113073m_oorier
murder93613783m__urder
order65019363___order
preorder1136463preorder
recorder11249633recorder
reorder8239483_reorder
resolder9259233resolder
resorter8312183resorter
solder73921343__solder
sonder73623523__sonder
sordor7310223__sordor
sorer56236593__sor_er
sorner64720393__sorner
sorter64425093__sorter
suborder1146663suborder
unsolder937213unsolder
visored1138143visor_ed

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 Filter1786911461620.423422437.4
2DLD Change Limit146162926.70321805.5
3Display Results92920.0462000.0
 (SQL Overall)178691927.17224915.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.