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

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

91 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
knavish174399(None) 
enravish1444242enravish
knaves13439522knaves_
knavishly2242312knavishly
knish1238602kn__ish
lavish124112982_lavish
ravish123414032_ravish
slavish1338232slavish
anguish11117633anguish
apish105116633__apish
atavism1238033atavism
atavist10311093atavist
aviso85713963__aviso
banish111416043_banish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
boarish123911913boarish
clayish1547943clayish
danish101513793_danish
deafish1438533deafish
dervish1436983dervish
dovish1338103_dovish
elvish1277563_elvish
english1137953english
evanish1337653evanish
famish14311843_famish
favism1437913_favism
garish104516923_garish
gnash9449833gna__sh
gnomish1345563gnomish
goatish1139563goatish
grayish1437813grayish
jadish17319903_jadish
kaddish16317973kaddish
kadis105921063k_adis_
kakis86116843k_akis_
kaliph1537873k_aliph
kanjis1735963kanjis_
kavas125919953k_avas_
kavass13517303k_avass
khadis1446913khadis_
khakis1265853khakis_
kiddish16276583kiddish
kingfish1944493kingfish
knacks11428543knacks_
knaps115511173kna_ps_
knars94416113kna_rs_
knaurs10466963knaurs_
knave12389463knav__e
knavery1733123knavery
knawes13328393knawes_
knives13458553knives_
kyanise14236143kyanise
latish92416173_latish
lavash12597373_lavash
mannish121710693mannish
marish114319053_marish
mavis105622723_mavis_
nabis76020583_nabis_
nanism8311203_nanism
naris55735293_naris_
naves87030383_naves_
navies95218623_navies
nazis145216083_nazis_
newish1237903_newish
oafish121311723_oafish
onanism9310133onanism
onanist7314633onanist
palish114718273_palish
panfish15229973panfish
parish115022353_parish
pavis106422733_pavis_
pavise114714803_pavise
peakish16268873peakish
peevish1535783peevish
planish12412053planish
radish103516913_radish
rakish134313963_rakish
rankish14510383rankish
rawish123012913_rawish
snappish1545243snappish
snash84815673sna__sh
tannish101610573tannish
toadish1139063toadish
unais53420773una_is_
unwish1239093un_wish
vanish121513213_vanish
weakish17217173weakish
wearish132310153wearish
zanyish2235903zanyish

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.453394461.4
2DLD Change Limit134027917.51617832.2
3Display Results91910.0461978.3
 (SQL Overall)178691918.01522294.6
 
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.