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

97 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
kleptos134436(None) 
klepto1244451klepto_
klephts1642182klephts
lentos65317402_lentos
lepton82510802_lepton
leptons91910432_leptons
adepts9117103adept_s
alephs1136533alep_hs
alerts64418223alert_s
altos55822953al__tos
bentos86218303_bentos
bleats85518613bleat_s
blets75324943ble_t_s
centos85920463_centos
cestos84718093_cestos
cleats84919313cleat_s
clefts114610163cleft_s
clepes104214623clep_es
clept95725773clept__
cryptos14337213cryptos
depots94716343_depots
depths12428573_depths
elector93313253elector
electors103013843electors
electros102811743electros
elects83315003elect_s
epos66723733__ep_os
fleets96915063fleet_s
gelatos83111513gelatos
ghettos1134473ghettos
gleets75315053gleet_s
gluepots1142983gluepots
heptose1237493_heptose
ileitis738063ileitis
keepers133410983keepers
keeps116020283keep__s
keets95123483k_eet_s
keleps12478813kelep__s
kelpies13289903kelpies
kelps115116423kelp__s
kelts95222633k_elt_s
kendos114510663k_endos
kenos95220623k_e_nos
kentes105118653k_entes
kepis115313363k_ep_is
keps106027303k_ep__s
kept106232943k_ept__
keto86223453k_e_to_
ketol95414003k_e_tol
ketols104210763k_e_tols
ketose105711813k_e_tose
kheths16495973khe_ths
khets124913433khe_t_s
klepht1535043klep_ht
klephtic1942873klephtic
kotos95717703k__otos
krypton1643283krypton
kryptons1743223kryptons
laptop1076813_laptop
laptops1166603_laptops
lector83514983_lector
lectors93415763_lectors
leets54927123_leet_s
lefts86517813_left_s
legatos82711183_legatos
lenos56024863_le_nos
lento57223393_lento_
lepers84817323_lepers
leprose938543_leprose
leprosy1244223_leprosy
leprous938843_leprous
lept66440883_lept__
lepta75714393_lept_a
leptin82512333_leptin
leptins92412693_leptins
lesbos837403_lesbos
lets47147943_le_t_s
lotos54724633_l_otos
lottos64613103_lottos
obentos936703obentos
oleates7417833oleates
oleos55419683ole__os
peplos101211543_peplos
pepos96620083_pep_os
pestos84719083_pestos
pleats85218593pleat_s
prestos93716083prestos
rectos85718783_rectos
repos74725793_rep_os
repots85621003_repots
repros84216003_repros
septs75420603_sept_s
sextos134012163_sextos
sklents11348163sklent_s
sleets64318873sleet_s
slept75728103slept__
sleuths1034743sleuths

Search took 7 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.390458182.1
2DLD Change Limit134027975.73623365.9
3Display Results97970.0303233.3
 (SQL Overall)178691976.15629027.1
 
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.