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

130 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
trembling143519(None) 
trebling1139871tre_bling
brambling1635542brambling
crumbling1655082crumbling
drumbling1544032drumbling
grumbling1544082grumbling
rambling131810772_rambling
rumbling131910102_rumbling
trameling1249052trameling
trampling1436972trampling
treadling1137502treadling
treddling1234422treddling
tremblier1343282tremblier
troubling1234942troubling
tumbling13219292t_umbling
ambling121411793__ambling
assembling1542883assembling
brabbling1334963brabbling
bramblings1742613bramblings
bumbling15249763_bumbling
creeling113513363cre_eling
cremating14312193cremating
creneling1247733creneling
crimpling1645343crimpling
crumbing15267813crumb_ing
crumblings1742513crumblings
crumpling1645323crumpling
cymbling1834773_cymbling
drabbling1544553drabbling
dribbling1533713dribbling
freckling1934703freckling
fribbling1733673fribbling
fumbling16208163_fumbling
gambling14218963_gambling
grabbling1564583grabbling
greenling1136753greenling
gremlin1035563grem_lin_
gremlins1136053grem_lins
humbling16208673_humbling
jumbling20217233_jumbling
kremlin1344213krem_lin_
kremlins1444483krem_lins
mumbling15198533_mumbling
pebbling1535073_pebbling
prefiling1549533prefiling
premising14412413premising
premixing2157803premixing
premolding1644673premolding
rabbling13239333_rabbling
reddling112911813_reddling
reedling102414273_reedling
reeling83126863_re_eling
refiling123116533_refiling
regaling10315363_regaling
remailing122412473_remailing
remaking152613303_remaking
remating112322413_remating
remelting12311703_remelting
remising112516453_remising
remixing182810333_remixing
remolding1338163_remolding
removing1439083_removing
reoiling93217213_reoiling
resembling1544733resembling
resiling93520173_resiling
resoling92916303_resoling
retiling93319483_retiling
reveling123117083_reveling
reviling122917213_reviling
rimpling13219663_rimpling
rubbling13238073_rubbling
rumbaing13185303_rumbaing
rumblings14184633_rumblings
rumpling13178763_rumpling
scrambling1743473scrambling
scumbling1634423scumbling
shambling1735593shambling
streeling10189483stre_eling
stumbling1435003stumbling
tabling103216033t__abling
teazling1856573t_eazling
teeming103513093teem__ing
telling83321083t_e_lling
temping122710693t_em_ping
tempting1357343t_empting
terming104016003term__ing
theming133610473them__ing
thumbing16245513thumb_ing
tombing123310533t_omb_ing
trachling1537823trachling
trailing92916093tr_ailing
tramelling1346373tramelling
tramline10311383tram_line
trammeling1544023trammeling
tramming13279343tram_ming
tramping132711273tram_ping
traveling1349053traveling
trawling122710783tr_awling
treading103515333tre_ading
treating92519613tre_ating
treeing83414303tre__eing
trekking1235543tre_kking
tremble1138003trembl__e
trembled1335253trembl_ed
trembler1235363trembl_er
tremblers1334483tremblers
trembles1237353trembl_es
trembliest1443633trembliest
trembly1435523trembl__y
tremolite1156893tremolite
tremulant1144923tremulant
trenching15227653trenching
trending103012833tre_nding
trickling1647723trickling
trifling122411503tr_ifling
trilling92815963tr_illing
trimming13318653trim_ming
trindling1137133trindling
tripling112712553tr_ipling
trolling93212493tr_olling
tromping13319603trom_ping
troweling1376363troweling
truckling1645073truckling
trumping13308733trum_ping
trundling1135003trundling
tumblings14184843t_umblings
tweedling1442533tweedling
wambling16198443_wambling
wimbling16186543_wimbling
wrestling1336063wrestling

Search took 9 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.703254183.5
2DLD Change Limit1486411307.34320242.5
3Display Results1301300.0632063.5
 (SQL Overall)1786911308.10922036.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.