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

127 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
trembly143552(None) 
trebly1138971tre_bly
tremble1138001tremble
atremble1244112atremble
brambly16296252brambly
crumbly16347522crumbly
grumbly15355402grumbly
rumbly134412162_rumbly
termly1138432term_ly
treacly1237092treacly
treble8311662tre_ble
trembled1335252trembled
trembler1235362trembler
trembles1237352trembles
tremolo946512tremolo
trimly114410892trim_ly
areally10411243areally
assembly1543853assembly
bramble133710033bramble
brumby15385953brumb_y
chimbly1974593chimbly
creamily1536363creamily
credibly1644713credibly
crumble133410403crumble
crumby15408113crumb_y
crumply16336093crumply
drably123511613dr_ably
dreamily1435143dreamily
dribbly15274953dribbly
drumble12337893drumble
drumly1235703drum_ly
dumbly14399603_dumbly
embay123410603__embay
emboly1336723__emboly
erectly1257483erectly
extremely2152643extremely
feebly1436653_feebly
freckly19124593freckly
freely12310963fre_ely
freshly16286833freshly
greatly1137613greatly
greenly11408193greenly
gremmy1454473grem_my
greyly13316543gre_yly
grimily1336523grimily
grimly12459933grim_ly
grumble12349233grumble
humbly164010523_humbly
mumbly15319463_mumbly
nimbly13388773_nimbly
numbly134410663_numbly
pebbly1545083_pebbly
preamble1436383preamble
prebuy1357423pre_buy
premold1247863premold
premolt11312073premolt
primely1457723primely
primly13439623prim_ly
rambla103510933_rambla
ramble104519973_ramble
really93315613_really
rebuy104714683_re_buy
redbay1238333_redbay
redly94217203_re_dly
refly113914563_re_fly
rely75428953_re__ly
remedy1237873_remedy
remelt85123123_remelt
remold93412973_remold
reply104015853_re_ply
rubbly133710613_rubbly
rumble103718813_rumble
rumply13348573_rumply
seemly1138433seem_ly
tamely113711953t_amely
taxably1936043taxably
telly84920823t_e_lly
temblor1144093t_emblor
temple102811333t_emple
tenably122210453tenably
terribly1344923terribly
tersely1038113tersely
thegnly1442613thegnly
thimble1435873thimble
timely113410113t_imely
tiredly1136803tire_dly
tomboy1358213t_omboy
traceably1646223traceably
tramel84113713tramel_
tramell9398703tramell
tramels93812493tramels
trample11299703trample
trampy13499253tram_py
tramway1544863tramway
treacle939973treacle
treadle8310103treadle
treaty94414353tre_aty
trebled1038483tre_bled
trebles9311443tre_bles
treddle936433treddle
trehala1045953trehala
tremblers1334483tremblers
tremblier1343283tremblier
trembling1435193trembling
tremolos1046043tremolos
tremor84210403trem_or
tremors93711233tremors
trendily1256443trendily
trendy10469603tre_ndy
tressy9448553tre_ssy
trestle72611363trestle
trevally1446343trevally
trey77228793tre___y
triable92515393triable
trickly16369893trickly
trigly103810943tr_igly
trilby1144973trilb_y
triply114211023tr_iply
tritely1039003tritely
trolly94012363tr_olly
trouble957713trouble
truly84111553tr__uly
tumble103215643t_umble
tunably12218293tunably
tuneably1346093tuneably
useably1287393useably
wambly16388663_wambly

Search took 10 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 Filter1786911340271.046170832.7
2DLD Change Limit1340271278.08016587.5
3Display Results1271270.0333848.5
 (SQL Overall)1786911279.15919509.9
 
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.