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

95 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
kneesies124554(None) 
newsies101310382_newsies
sneeshes1136512sneeshes
andesites1048553andesites
anergies9310453anergies
beedies10314203_beedies
bheesties1443923bheesties
cheeses123613103chees_es
cheesier1335963cheesier
cheesiest1436323cheesiest
creepies1239613creepies
creeses93914623crees_es
creeshes1336953creeshes
easies64126633__easies
enemies9313693en_emies
energies9310783energies
enmeshes1345343enmeshes
freebies1337873freebies
freesias1146333freesias
geneses82613523genes_es
genesis82510823genesi_s
gneisses933673gneisses
greenies9312673greenies
heresies11312693heresies
inmeshes1345613inmeshes
kebbies1537253k_ebbies
keester11319913k_eester
keesters12319593k_eesters
keeves133711993k_ee_ves
kellies113516853k_ellies
kelpies13289903k_elpies
kenosis11369003kenosi_s
kenosises1345143kenosises
kerries113317913k_erries
kewpies16246923k_ewpies
kineses113111253kines_es
kinesics14286283kinesics
kinesis11259593kinesi_s
knaveries1645013knaveries
kneecaps1641963kneecaps
kneeholes16113293kneeholes
kneeing12226523knee_ing
kneeled12328073knee_led
kneeler11277573knee_ler
kneelers12226213kneelers
kneeling13287783kneeling
kneels10408933knee__ls
kneepads15102253kneepads
kneepans1462733kneepans
kneepiece1752143kneepiece
kneepieces1851983kneepieces
knees95114873kn_e__es
kneesock1342033kneesock
kneesocks1451813kneesocks
knesset11310413kn_esset
knessets1243173knessets
knishes1438263kn_ishes
neddies92710703_neddies
needier84010623_needier
neediest92611303_neediest
needles83211563_needles
nellies73418723_nellies
nemeses948663_nemes_es
nemesis937373_nemesi_s
nesses64718323_n_esses
newbies12147423_newbies
newies91014073_n_ewies
newsie9138213_newsie_
newsier10147223_newsier
newsiest11107483_newsiest
noesis6311443_noesi_s
noesises838503_noesises
onenesses9311823onenesses
peeries93623023_peeries
poesies93217403_poesies
preemies12512193preemies
sheenies111411543sheenies
sneerier878103sneerier
sneeriest939313sneeriest
sneezes16278503snee_zes
sneezier1774333sneezier
sneeziest1845153sneeziest
steelies8312553steelies
sweenies11148763sweenies
sweeties11159723sweeties
tweenies11146393tweenies
uneases73316263uneas_es
uneasier836963uneasier
uneasiest946563uneasiest
unmeshes1346153unmeshes
veeries102916893_veeries
veneries112815033veneries
weenies102915093_weenies
weepies122811743_weepies
wheelies1437863wheelies

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.423422437.4
2DLD Change Limit146162957.23320207.7
3Display Results95950.0462065.2
 (SQL Overall)178691957.70223200.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.