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

137 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
klepto124445(None) 
kleptos1344361kleptos
clept95725772clept_
kept106232942k_ept_
keto86223452k_e_to
klepht1535042klepht
klephts1642182klephts
lento57223392_lento
lept66440882_lept_
lepta75714392_lepta
lepton82510802_lepton
slept75728102slept_
adept81219643adept_
adepts9117103adepts
aleph10311393alep_h
alephs1136533alephs
alert54740653alert_
alerts64418223alerts
alto47831263al__to
bento75922953_bento
bleat75737003bleat_
bleats85518613bleats
blent76230953blent_
blest76431723blest_
blet66247673ble_t_
blets75324943ble_ts
blotto8198443blotto
cento76625173_cento
clapt98027173clapt_
cleat76335063cleat_
cleats84919313cleats
cleft106222853cleft_
clefts114610163clefts
clepe94617383clep_e
cleped115114113cleped
clepes104214623clepes
clipt96324273clipt_
crept95125893crept_
crypto13367273crypto
depot85727923_depot
depth114311853_depth
elect74327033elect_
elector93313253elector
electro92810033electro
elects83315003elects
fleet85932333fleet_
fleets96915063fleets
gelato73812953gelato
ghetto1036073ghetto
gleet65532343gleet_
gleets75315053gleets
gleety10479193gleety
gluepot1045103gluepot
inept73622153inept_
keep106329823keep__
keeper123811923keeper
keeps116020283keep_s
keet85347343k_eet_
keets95123483k_eets
kelep116014563kelep__
keleps12478813kelep_s
kelp105322803kelp__
kelped13449553kelped
kelpie12308613kelpie
kelps115116423kelp_s
kelpy145110683kelp_y
kelt85343193k_elt_
kelts95222633k_elts
kempt134318463kempt_
kendo105113223k_endo
keno87926433k_e_no
kent86846963k_ent_
kente95821073k_ente
kep96437203k_ep__
kepi105315633k_ep_i
kepis115313363k_epis
keps106027303k_ep_s
ketol95414003k_e_tol
khet116328623khe_t_
kheth15509753khe_th
khets124913433khe_ts
klephtic1942873klephtic
klutz1868853kl_utz
knelt94617683knelt_
koto86323473k__oto
krypton1643283krypton
laptop1076813_laptop
leapt75027473_leapt_
lector83514983_lector
leet45957903_leet_
leets54927123_leets
left76340483_left_
lefts86517813_lefts
lefty115613563_lefty
legato72810953_legato
leno47331393_le_no
lent46360533_lent_
lentos65317403_lentos
leper74820743_leper
leptin82512333_leptin
leptons91910433_leptons
lesbo739253_lesbo
lest46956323_lest_
let36481473_le_t_
lets47147943_le_ts
levo76820063_le_vo
lotto55217573_lotto
obento837893obento
oleate6318883oleate
oleo46630483ole__o
pepo87622153_pep_o
pesto75723723_pesto
petto76021043_petto
pleat74734473pleat_
pleats85218593pleats
plenty11311413plenty
presto84216203presto
recto74520803_recto
repo66027543_rep_o
repot75132623_repot
repro75315913_repro
sept65844363_sept_
septa75518083_septa
septs75420603_septs
sexto124415453_sexto
sklent103614353sklent_
sklents11348163sklents
sleazo15257523sleazo
sleet55639133sleet_
sleets64318873sleets
sleety94112653sleety
sleuth937233sleuth
slipt76627483slipt_
swept105720603swept_
veto76622993_ve_to
wept95635053_wept_
yclept1336013yclept_

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161375.03022408.7
3Display Results1371370.0304566.7
 (SQL Overall)1786911375.43632871.8
 
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.