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

102 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
misbinds134516(None) 
misbind1258271misbind_
disbands1237352disbands
misbias1139082misbi_as
misbills1246082misbills
misbrands1445152misbrands
misbuilds1442392misbuilds
missends11368232missends
mistends11419592mistends
binds86627473___binds
cowbinds1634453cowbinds
disband1138243disband_
disbuds11125243disb_uds
dispends12308533dispends
distends10339823distends
exscinds1842533exscinds
fishings15307693fishings
hissings12556753hissings
husbands1444763husbands
inwinds11216273_inwinds
islands837323_islands
listings93310043listings
masjids17175403masji_ds
maskings15448753maskings
maybirds1643323maybirds
mestinos1048163mestinos
midlands1245543midlands
midlines112613333midlines
millines102718063millines
millings113712583millings
minds85427123m___inds
minings103912073mi_nings
minuends1143893minuends
mirins83918903mi_rin_s
misadds1136303mis_adds
misaims11310113misai_ms
misbegins1444893misbegin_s
misbiases1346253misbiases
misbill1137033misbi_ll
misbinding1645063misbinding
misbound1344933misbound_
misbrand1346413misbrand_
misbuild1343163misbuild_
miscites12313783miscites
miscoins12311083miscoin_s
misdeeds12276813misdeeds
misdials1137493misdials
misdid10510573misdi_d_
misdoings1344423misdoings
misfeeds14315623misfeeds
misfields15223653misfields
misfiles133110983misfiles
misfires132210583misfires
misfits12279663misfi_ts
misgives14329293misgives
mishits122513083mishi_ts
misjoins1736913misjoin_s
miskicks1544763miskicks
misleads11358543misleads
mislies92922283misli_es
mislikes143311833mislikes
mislives132912153mislives
mispaints13106183mispaints
mispens11311073mispen_s
mispoints13106633mispoints
misprints13107223misprints
misreads11268923misreads
missend104411373missend_
missies93423983missi_es
missiles103015083missiles
missing103619073missin_g
missions10311903missions
missis84417503missi__s
missises103513693missises
missives133212843missives
missounds1243533missounds
misspends1443853misspends
mistend103812523mistend_
misthinks1843353misthinks
mistimes12612613mistimes
mistiness111911633mistiness
misting103623383mistin_g
mistunes10311133mistunes
miswords1446603miswords
moshings14367333moshings
muscids12187973musci_ds
musings10389543mus_ings
musjids17185713musji_ds
muslins9312213muslin_s
mysids1246563mys_i_ds
oilbirds1143183oilbirds
piscinas1275483piscinas
prebinds13357733prebinds
rebinds104511873_rebinds
rescinds1136333rescinds
ribands10208393ri_bands
ribbands1344563ribbands
ribbings13275923ribbings
risings83211893ris_ings
siskins1159583siskin_s
unbinds10267353_unbinds
upbinds12234813_upbinds

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.1731032896.0
2DLD Change Limit1461621027.23620199.3
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.43924020.8
 
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.