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

106 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
misknew163388(None) 
misknow1643211misknow
misdrew1335832misdrew
misgrew1335522misgrew
miskeep1536402miskeep
misknown1742532misknown
misknows1743062misknows
askew12529413_ask_ew
disked125015763disk_ed
fishnet13410343fishnet
knew115912123___knew
masked134316523mask_ed
maskeg13388693mask_eg
masker124416103mask_er
masoned1039803masoned
mesne75116293mes_ne_
mesnes85216213mes_nes
mickey174211853mick_ey
mickle143715133mickle_
mickler153310233mickler
mickles153415003mickles
mike105535283mi_k_e_
miked125020453mi_k_ed
mikes115129893mi_k_es
mikveh18132543mi_kveh
mildew12319043mi_ldew
milked134612573milk_ed
milker124814323milk_er
milkier133411163milkier
milkmen1565213milkmen
milneb1095953mi_lneb
mine67256153mi__ne_
mined85333353mi__ned
miner76933543mi__ner
mines75651953mi__nes
minke115421763mink_e_
minkes124618783mink_es
minnow1135583mi_nnow
mirker123712693mirk_er
mirkier13319053mirkier
misate81222693misate_
misaver1249813misaver
miscue10412223miscue_
miscued1239293miscued
miscues11312393miscues
misdeed113211053misdeed
misdeem12217873misdeem
misdoer1048633misdoer
misdoes10312493misdoes
misdone10310863misdone_
misdraw1345623misdraw
mise66043573mis__e_
misenter10310833misenter
miser75430403mis__er
mises74740563mis__es
misfed124113023mis_fed
misfeed13389683misfeed
misgrow1344433misgrow
misinfer1345323misinfer
misinter1038833misinter
miskal123710263misk_al
miskals13369763miskals
miskeeps1644163miskeeps
miskept1538923miskept
miskick1435613miskick
misled94719313mis_led
mislie83219153mislie_
mislies92922283mislies
mismeet113215163mismeet
mismet103722373mis_met
mispen10312173mis_pen
mispens11311073mispens
mispled12310463mispled
missed94423603mis_sed
missel85216523mis_sel
missend104411373missend
missent94318713missent
misses85130873mis_ses
misset85028153mis_set
missies93423983missies
misstep11158463misstep
mistbow1443993mistbow
misted93625823mis_ted
mistend103812523mistend
mister84728563mis_ter
misthrew16124763misthrew
mistier93418713mistier
mistune9310653mistune_
mistuned1157723mistuned
mistunes10311133mistunes
misuse83213643misuse_
misused104111273misused
misuser93210443misuser
misuses93216023misuses
muskeg13338183musk_eg
musket122818203musk_et
muskie123412533muskie_
muskier134312723muskier
muskies133614663muskies
risked115514633risk_ed
risker105414493risk_er
riskier1138423riskier
sinew84718923__sinew
skew116218763__sk_ew
tisane6311573tisane_
tisanes7311853tisanes

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271068.01616719.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.21521751.8
 
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.