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

147 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
trembler123536(None) 
tremble1138001tremble_
trembled1335251trembled
tremblers1334481tremblers
trembles1237351trembles
tremblier1343281tremblier
atremble1244112atremble_
grumbler13866682grumbler
rambler113313262_rambler
rumbler113514112_rumbler
temblor1144092t_emblor
trampler12278012trampler
treadler936862treadler
treble8311662tre_ble_
trebled1038482tre_bled
trebles9311442tre_bles
trembly1435522trembl_y
troubler1035292troubler
tumbler113412822t_umbler
ambler104916453__ambler
assembler1343613assembler
brabbler11397373brabbler
bramble133710033bramble_
brambled15316733brambled
brambles14308973brambles
bramblier1543503bramblier
bumbler134013233_bumbler
crumber13339643crumb_er
crumbier1456363crumbier
crumble133410403crumble_
crumbled15357443crumbled
crumbles14329683crumbles
crumblier1543873crumblier
dribbler13316313dribbler
drumble12337893drumble_
drumbled14266033drumbled
drumbles13277723drumbles
ember95516803__emb_er
emblem1237583__emblem
feebler1235823_feebler
fribbler15265953fribbler
fumbler143610813_fumbler
gambler123612683_gambler
grabbler13377693grabbler
grumble12349233grumble_
grumbled14256753grumbled
grumblers14245023grumblers
grumbles13288873grumbles
humbler143411943_humbler
jumbler183910273_jumbler
member12258853_memb_er
mumbler133510913_mumbler
nimbler11358063_nimbler
preamble1436383preamble_
preambled1643893preambled
preambles1545333preambles
premier113515633prem_ier
premolar1246633premolar
rabbler113514093_rabbler
ramble104519973_ramble_
rambled123913523_rambled
ramblers124010373_ramblers
rambles113118313_rambles
realer63528593_re_aler
reeler63822573_re_eler
regaler83814623_regaler
remaker133813173_remaker
remoter94815973_remoter
remover124612273_remover
resembler1344583resembler
reveler104116343_reveler
reviler104314973_reviler
rumble103718813_rumble_
rumbled124514593_rumbled
rumblers123610743_rumblers
rumbles114018393_rumbles
scrambler15165043scrambler
stumbler1235813stumbler
teemer85515743teem__er
teller63519813t_e_ller
temblors1244463t_emblors
temper103914093t_em_per
templar1145643t_emplar
temple102811333t_emple_
templed12278553t_empled
temples112610893t_emples
templet112712003t_emplet
tempter11358213t_empter
termer85717253term__er
thimble1435873thimble_
thimbles1536023thimbles
timber104012683t_imb_er
trailer73015393tr_ailer
trameled11309073trameled
trammeler1343223trammeler
tramper113812163tram_per
trampier12318243trampier
trample11299703trample_
trampled13247903trampled
tramplers13305883tramplers
tramples122610203tramples
traveler11328433traveler
trawler104011903tr_awler
treacle939973treacle_
treacles1039703treacles
treaclier1144153treaclier
treader84113833tre_ader
treadle8310103treadle_
treadled1067123treadled
treadlers1045893treadlers
treadles939703treadles
treater74219833tre_ater
trebly1138973tre_bl_y
treddle936433treddle_
treddled1134473treddled
treddles1036263treddles
trekker1034733tre_kker
trembliest1443633trembliest
trembling1435183trembling
tremolo946513tremol_o
tremolos1046043tremolos
tremor84210393trem__or
trencher13279313trencher
trendier937913trendier
tressier847963tressier
trestle72611363trestle_
trestles83012553trestles
triable92515393triable_
trifler103912153tr_ifler
triller74215893tr_iller
trimer85717153trim__er
trimeter10310083trimeter
trimmer113610833trim_mer
troller73913173tr_oller
trouble957713trouble_
troubled1134983troubled
troublers1134993troublers
troubles1057193troubles
troweler11106063troweler
truckler14297453truckler
trundler9256153trundler
tumble103215643t_umble_
tumbled123412243t_umbled
tumblers123110623t_umblers
tumbles113816023t_umbles
tummler11266613t_ummler
wrestler11306993wrestler

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621479.23615825.2
3Display Results1471470.0761934.2
 (SQL Overall)1786911479.46818873.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.