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

139 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
mislayer133750(None) 
mislayers1445931mislayers
bilayer12347802bi_layer
displayer1545832displayer
inlayer1036932_inlayer
manslayer1442952manslayer
minelayer1453502minelayer
misalter1038342misalter
misaver1249812mis_aver
mislabel1296162mislabel
mislabor1244502mislabor
mislay113510682mislay__
mislays12349242mislay_s
misleader1246502misleader
misliker14319572misliker
misplayed1745302misplayed
mistaker14109322mistaker
slayer93916332__slayer
allayer10148213_allayer
assayer1035573_assayer
belayer12339503_belayer
bilayers13296913bi_layers
delayer113010533_delayer
dilater83515643di_later
disliker13358643disliker
dismaler1137903dismaler
dismayed1535743dismayed
displacer1446433displacer
displayed1645883displayed
displayers1654823displayers
enslaver1144713enslaver
essayer1033943_essayer
flayer124713563__flayer
inlayers1135633_inlayers
islander946103_islander
layer84626473___layer
manslayers1542683manslayers
massager1136873massager
midlifer14215793midlifer
milage93414123mi_lage_
milages103114403mi_lages
milder93818453mi_l_der
miler75733063mi_l__er
milker124814323mi_l_ker
milkier133411163mi_lkier
millage103112743millage_
millages113212893millages
miller84625413mi_l_ler
millier93716703mi_llier
milliner102811863milliner
milter84921233mi_l_ter
miltier93214963mi_ltier
minelayers1543453minelayers
misalters1136903misalters
misate81222693mis_ate_
misavers1348053mis_avers
miscaller1346283miscaller
misdate101413963misdate_
misdated121211113misdated
misdates111113623misdates
misdealer1245593misdealer
misdoer1048633mis_doer
misease92713043misease_
miseases102614343miseases
miseaten10310773miseaten
misenter10310833misenter
miser75430403mis___er
misgave13298283misgave_
mishanter1446453mishanter
misinfer1345323misinfer
misinter1038833misinter
mislabels13114313mislabels
mislabors1344503mislabors
mislaid1039293misla_id
mislain9311243misla_in
mislaying1557913mislaying
misleaders1345203misleaders
misleared1277453misleared
misled94719313misl__ed
mislie83219153misl_ie_
mislies92922283misl_ies
mislike132914833mislike_
misliked15319513misliked
mislikers15317053mislikers
mislikes143311833mislikes
mislive122812693mislive_
mislived14328783mislived
mislives132912153mislives
mismade12129353mismade_
mismake15139373mismake_
mismakes16129883mismakes
mismate111415353mismate_
mismated131111333mismated
mismates121114553mismates
misname11119483misname_
misnamed13127593misnamed
misnames12119883misnames
misnomer1247143misnomer
misorder1147273misorder
mispage12310523mispage_
mispaged1438243mispaged
mispages13311183mispages
misplace1437553misplace_
misplaced1646253misplaced
misplaces1537953misplaces
misplay1436383misplay__
misplays1555543misplay_s
misrate91319143misrate_
misrated111315383misrated
misrates101318233misrates
misrefer1346103misrefer
missay114112143missay__
missays124010253missay_s
misshaper1644403misshaper
missteer1037223missteer
mistake131312613mistake_
mistaken14147823mistaken
mistakers15117073mistakers
mistakes141213403mistakes
mister84728563mis__ter
mistier93418713mis_tier
misuser93210443mis_user
monolayer1444793monolayer
motleyer1343263motleyer
pillager11278543pillager
player115215213__player
sayer84926553__s_ayer
slaker104219273__slaker
slater64429183__slater
slaver94419613__slaver
slayed104716223__slayed
slayers104513323__slayers
slyer85515123__sl_yer
stayer94516483__stayer
swayer125210973__swayer
vilayet1348533vi_layet
villager12267503villager
violater1137243violater
waylayer1743153waylayer

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.1701051123.5
2DLD Change Limit1461621397.05020732.2
3Display Results1391390.0602316.7
 (SQL Overall)1786911397.28024545.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.