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

91 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
tumbrels1228573(None) 
timbrels12265341timbrels
tumbrel11406851tumbrel_
tumbrils12255371tumbrils
gambrels1334212gambrels
timbrel11306552timbrel_
timbres11249332timbre_s
tumblers123110622tumblers
tumbles113816022tumble_s
tumbril11256402tumbril_
umbels104510582_umb_els
bulbels11398013bulb_els
bumblers143710733bumblers
bumbles134016843bumble_s
cumberers15175993cumberers
cumbers134515393cumb_ers
cumbrous1446173cumbrous
dumbbell1542143dumbbell
dumbbells1641773dumbbells
dumbness1334613dumbness
fumblers15318713fumblers
fumbles143514413fumble_s
gambrel1235453gambrel_
gomerels1144563gomerels
gumballs1345313gumballs
gumboils1343893gumboils
gumtrees1143873gumtrees
hombres14369873hombre_s
humblers15379803humblers
humbles143215803humble_s
humerals1347163humerals
jumbals18106533jumb_als
jumblers19358323jumblers
jumbles183013323jumble_s
jurels133710583ju__rels
kummels15234793kum_mels
lumberers13196013lumberers
lumberly1544673lumberly
lumbers113815913lumb_ers
morels84820013__morels
mumblers14328763mumblers
mumbles133014433mumble_s
nombrils1244513nombrils
numberers13165153numberers
numbers113711243numb_ers
numbles113814273numble_s
numbness1234413numbness
numerals1047333numerals
ombres103911133_ombre_s
pummels13236543pum_mels
quarrels1735073quarrels
rubels84112993ru_b_els
rumblers123610743rumblers
rumbles114018393rumble_s
sombrely1543693sombrely
staumrels1141663staum_rels
stumblers1334373stumblers
stumbles1237493stumble_s
thumbless1643423thumbless
timbales12227843timbales
timbals11239523timb_als
timbers113111833timb_ers
timbral11237183timbral_
timbre10328623timbre__
tombless1236773tombless
tubbers113411243tu_bbers
tubers85017023tu_b_ers
tubes74826453tu_b_e_s
tubfuls1245473tu_bfuls
tubules9310233tu_bules
tumble103215643tumb__le
tumbled123412243tumble_d
tumbler113412823tumble_r
tummies113012033tummie_s
tummlers12295703tummlers
tumoral938133tumoral_
tumorous1046593tumorous
tumors8810603tumor__s
tunnels7328723tu_nnels
turrets73010673tu_rrets
tutoress845093tutoress
tuyeres10417793tuyere_s
tymbals14265723tymb_als
umbel93612833_umb_el_
umbers104215203_umb_ers
umbles103817483_umble_s
umbral1038623_umbral_
umbras1038633_umbr_as
umbrella1243263_umbrella
umbrellas1343093_umbrellas
whimbrels1941833whimbrels

Search took 7 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.1731032896.0
2DLD Change Limit146162916.32623105.0
3Display Results91910.0332757.6
 (SQL Overall)178691916.53227356.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.