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

137 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
miscoded143798(None) 
miscode12310411miscode_
miscodes13310421miscodes
discoed11312482disco_ed
discorded1438132discorded
misadded1335752misadded
miscited13310422miscited
miscoined1448442miscoined
miscooked1844692miscooked
miscopied1647172miscopied
miscued1239292misc_ued
mislodged1443842mislodged
mismoved1635652mismoved
misworded1644232misworded
misyoked1834622misyoked
absconded1543003absconded
bishoped1644663bishoped
cascaded14135703cascaded
ciscoes113610733cisco_es
coded95433183___coded
decoded123212393_decoded
discarded1437083discarded
discased122510853discased
disced104914653disc__ed
disclosed1347363disclosed
discoid11311243disco_id
discord1139993disco_rd
discover1439563discover
dislodged1344573dislodged
disploded1446543disploded
disposed12310943disposed
disrobed1238093disrobed
disyoked1745463disyoked
encoded1139043_encoded
escoted1038183_escoted
imploded14145073imploded
masoned1039803mas_oned
miaoued1034583mi_aoued
miaowed1333883mi_aowed
miched143913393mi_c_hed
milded104416153mi__lded
mimeoed1235193mimeo_ed
minced114114913minc__ed
minded103817833mi__nded
minored10310103mi_nored
mirrored1145773mirrored
misacted1338673misacted
misadd1037163mis_ad_d
misaimed1338093misaimed
misatoned1246693misatoned
misbound1344933misbound
miscalled1447443miscalled
mischief1846423mischief
mischose1547263mischose_
mischosen1644003mischosen
miscite11314383miscite_
miscites12313783miscites
miscoding1538183miscoding
miscoin11311433misco_in
miscoins12311083miscoins
miscolor1245603miscolor
miscolored1544703miscolored
miscook1546473misco_ok
miscooks1645463miscooks
miscopies1549613miscopies
miscopy1636663misco_py
miscount1299473miscount
miscounted1546063miscounted
miscue10412223misc_ue_
miscues11312393misc_ues
misdated121211123misdated
misdeed113211053mis_deed
misdid10510573mis__did
misdoer1048633misdo_er
misdoes10312493misdo_es
misdone10310863misdone_
misfed124113023mis__fed
misfeed13389683mis_feed
misfiled14278653misfiled
misfired14238543misfired
misformed1745243misformed
misgraded1446233misgraded
misguided14144653misguided
misjoined1945453misjoined
misjudged2142563misjudged
misled94719313mis__led
misliked15319513misliked
mislived14328783mislived
mislodge1244113mislodge
mislodges1344363mislodges
mismade12129353mismade_
mismated131111333mismated
mismove1437083mismove_
mismoves1537293mismoves
misnamed13127593misnamed
misnomer1247143misnomer
misorder1147283misorder
mispaged1438243mispaged
mispled12310463mis_pled
mispoised1446803mispoised
misquoted2144083misquoted
misrated111315383misrated
misrecorded1752193misrecorded
misrouted1247303misrouted
misruled1137083misruled
missed94423603mis__sed
missioned1248603missioned
missorted1247033missorted
missound1145113missound
missounded1443023missounded
misted93625823mis__ted
mistended13137333mistended
mistimed1339123mistimed
mistuned1157723mistuned
mistyped1685173mistyped
misused104111283mis_used
misword1338413miswo_rd
misyoke1635823misyoke_
misyokes1735513misyokes
muscadel1343763muscadel
muscadet1348143muscadet
muscled1237783musc_led
picoted1239213pi_coted
pistoled11259593pistoled
precoded1438863precoded
recoded113115043_recoded
rescored114513103rescored
scolded11358863__scolded
scoped115116663__scoped
scored94621133__scored
scowed124413833__scowed
uncoded11312743_uncoded
viscoid1337023visco_id
viscose1237863viscose_
viscoses1338343viscoses
visioned1247013visioned
visored1138143vis_ored

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.420425454.8
2DLD Change Limit1461621376.80021494.4
3Display Results1371370.0602283.3
 (SQL Overall)1786911377.28024545.5
 
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.