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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

44 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
misbehavers215186(None) 
misbehaver2052141misbehaver_
misbehaves2042471misbehave_s
misbehave1942232misbehave__
misbehaved2152092misbehave_d
misbehaviors226952misbehaviors
behavers16205613___behavers
misavers1348063mis___avers
misbehaving2272273misbehaving
misbehavior2161053misbehavior
misbelievers19112113misbelievers
misdealers1344613misde_alers
misleaders1345203misle_aders
misshapers1743403mis_shapers
beavers124417324___be_avers
behaver15206724___behaver_
behaves15198524___behave_s
disbelievers18111904disbelievers
dissevers1386864disse__vers
lifesavers1651764li_fesavers
minelayers1543454mi_nelayers
misaver1249814mis___aver_
misbecame1762724misbecame__
misbecomes1872964misbecome_s
misbeliefs1742754misbe_liefs
misbeliever18122704misbeliever_
misbelieves18123104misbelieves
misbiases1346254misb_iase_s
misdealer1245594misde_aler_
miseases102614344mis_e_ase_s
misenters1139534mis_e_nters
misfeasors1552514misfe_asors
mishanters1544984mis__hanters
mishears1338324mishe_a__rs
mislayers1445944mis__layers
misleader1246504misle_ader_
misrefers1445364misre__fers
misrelates1247624misrelate_s
misrenders1375354misre_nders
misshaper1644404mis_shaper_
misshapes1645914mis_shape_s
mistakers15117084mis__takers
shavers134115094__s__havers
timesavers1552164ti_mesavers

Search took 9 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 Filter1786911488190.440406115.9
2DLD Change Limit148819448.23318075.9
3Display Results44440.0162750.0
 (SQL Overall)178691448.68920565.2
 
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.