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

121 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
threeping1510480(None) 
threaping15106111threaping
cheeping16329552ch_eeping
creeping133310102_creeping
threading14107592threading
threating131010052threating
threshing1645662threshing
treeing83414302t_ree_ing
wheeping17337102wh_eeping
agreeing10295903agree_ing
beeping124013913__beeping
beweeping1743933beweeping
bleeping13377933_bleeping
breeding123411843_breeding
breezing20368133_breezing
careening12310013careening
careering12311203careering
cheeking18349083ch_eeking
cheering143612703ch_eering
cheesing14349413ch_eesing
creeling113513363_creeling
creping122913653_cr_eping
dreeing94311183_dree_ing
freeing113713913_free_ing
freezing21308323_freezing
greeing93613783_gree_ing
greening103112533_greening
greeting103112353_greeting
heaping133015853_h_eaping
heeding123515063_h_eeding
heeling113618513_h_eeling
heezing20349873_h_eezing
helping133512223_h_elping
jeeping174010333__jeeping
keeping144012543__keeping
peeping123615213__peeping
phreaking1936473phreaking
preeing103817673_pree_ing
preening113115843_preening
prepping12309763_prepping
pureeing1137273puree_ing
reaping103621213__reaping
reeding94124133__reeding
reefing114016863__reefing
reeking123318643__reeking
reeling83126863__reeling
reeving113717663__reeving
repping123314983__repping
screeding1336323screeding
screening1247193screening
seeping103817913__seeping
sheening123010803sh_eening
sheering123715103sh_eering
sheeting122712833sh_eeting
shlepping1733393shlepping
shredding1544513shredding
shrewing15228093shr_ewing
shrieking1734583shrieking
shrieving1633973shrieving
shrimping1734063shrimping
sleeping113812053_sleeping
steeping113412583_steeping
streeking14217453streeking
streeling10189483streeling
sweeping14389143_sweeping
targeting1137303targeting
teeing73916973t__ee_ing
teeming103513093t__eeming
temping122710693t__emping
theelin1038003th_eelin_
theelins1137643th_eelins
theming133610473th__eming
therein102310353there_in_
theremin13107283theremin_
theremins14106053theremins
thieving1535143th_ieving
tholepin1344113tholepin_
tholepins1443963tholepins
thralling13256833thralling
thrashing1635683thrashing
thrawing1535963thr_awing
threatening1543063threatening
threep115910113threep___
threeped1454373threep_ed
threepence1752033threepence
threepenny1851013threepenny
threeps12687043threep__s
threonine1245103threonine
thrilling13276693thrilling
thriving15246353thr_iving
throating1398403throating
throbbing1743533throbbing
thronging1435073thronging
throning1238863thr_oning
throwing1536723thr_owing
thrumming1742903thrumming
thrusting1335013thrusting
thumping16296713th_umping
tramping132711273t_ramping
trapping132911393t_rapping
treading103515333t_reading
treating92519613t_reating
trebling1139873t_rebling
trekking1235543t_rekking
trending103012833t_rending
trepang10257293t_r_epang
tripping133210923t_ripping
tromping13319603t_romping
trooping112710283t_rooping
trouping11249503t_rouping
trueing83410183t_rue_ing
trumping13308733t_rumping
tweeting12267033t_weeting
tweezing21384113t_weezing
unreeling1038983unreeling
unreeving1336213unreeving
weeping133613673__weeping
wheeling15318603wh_eeling
wheepling1843323wh_eepling
wheezing24315383wh_eezing
whelping17245333wh_elping

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411217.28320409.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.73523101.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.