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

74 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
klephts164218(None) 
klepht1535041klepht_
alephs1136532aleph_s
klephtic1942872klephtic
klepto1244452klep_to
kleptos1344362kleptos
adepts9117103adep_ts
aleph10311393aleph__
alerts64418223ale_rts
alights113211433alights
alphas1139513al_phas
bleats85518613ble_ats
blets75324943ble__ts
blights133110213blights
cleats84919313cle_ats
clefts114610163cle_fts
clepes104214623clep_es
clept95725773clep_t_
depots94716343_depots
depths12428573_depths
elects83315003ele_cts
elegits8149343elegits
elephants1444803elephants
ephas10311543__ephas
fleapits1363253fleapits
fleches153411443fleches
fleets96915063fle_ets
fleshes133913273fleshes
flights143310983flights
gleets75315053gle_ets
gluepots1142983gluepots
glyphs1534303glyph_s
kajeputs2141763kajeputs
kaliphs1634293kaliph_s
kaphs144911503k_aph_s
keepers133410983keepers
keeps116020283keep__s
keets95123483k_e_ets
keleps12478813kelep__s
kelpies13289903kelpies
kelps115116423kelp__s
kelts95222633k_e_lts
kepis115313363k_ep_is
keps106027303k_ep__s
kept106232943k_ep_t_
khaphs18394323khaph_s
kheths16495973kheth_s
khets124913433khe__ts
knights1545653knights
kophs145010933k_oph_s
leasts64616413_leasts
leches115421313_leches
leets54927123_le_ets
lefts86517813_le_fts
legits71313003_legits
lehrs86111133_le_hrs
lepers84817323_lepers
lept66440883_lep_t_
lepta75714393_lep_ta
lethes94818083_lethes
lets47147943_le__ts
lichts113712383_lichts
lights104519913_lights
pleats85218593ple_ats
plights13299313plights
repots85621003_repots
septs75420603_sep_ts
sklents11348163skle_nts
sleets64318873sle_ets
sleights12275913sleights
slept75728103slep_t_
sleuths1034743sleuths
slights112810723slights
wechts1446253_wechts

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 Filter1786911340270.406440125.6
2DLD Change Limit134027746.89319443.9
3Display Results74740.0135692.3
 (SQL Overall)178691747.31224438.0
 
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.