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
timbrel11306562timbrel_
timbres11249352timbre_s
tumblers123110622tumblers
tumbles113816022tumble_s
tumbril11256402tumbril_
umbels104510592_umb_els
bulbels11398013bulb_els
bumblers143710733bumblers
bumbles134016843bumble_s
cumberers15176003cumberers
cumbers134515413cumb_ers
cumbrous1446173cumbrous
dumbbell1542143dumbbell
dumbbells1641773dumbbells
dumbness1334613dumbness
fumblers15318713fumblers
fumbles143514413fumble_s
gambrel1235453gambrel_
gomerels1144563gomerels
gumballs1345313gumballs
gumboils1343893gumboils
gumtrees1143883gumtrees
hombres14369873hombre_s
humblers15379803humblers
humbles143215803humble_s
humerals1347173humerals
jumbals18106533jumb_als
jumblers19358323jumblers
jumbles183013323jumble_s
jurels133710583ju__rels
kummels15234793kum_mels
lumberers13196013lumberers
lumberly1544683lumberly
lumbers113815913lumb_ers
morels84820013__morels
mumblers14328763mumblers
mumbles133014433mumble_s
nombrils1244513nombrils
numberers13165153numberers
numbers113711243numb_ers
numbles113814273numble_s
numbness1234413numbness
numerals1047333numerals
ombres103911143_ombre_s
pummels13236543pum_mels
quarrels1735083quarrels
rubels84112993ru_b_els
rumblers123610743rumblers
rumbles114018393rumble_s
sombrely1543703sombrely
staumrels1141663staum_rels
stumblers1334383stumblers
stumbles1237493stumble_s
thumbless1643433thumbless
timbales12227843timbales
timbals11239533timb_als
timbers113111853timb_ers
timbral11237193timbral_
timbre10328633timbre__
tombless1236783tombless
tubbers113411253tu_bbers
tubers85017033tu_b_ers
tubes74826453tu_b_e_s
tubfuls1245483tu_bfuls
tubules9310233tu_bules
tumble103215643tumb__le
tumbled123412243tumble_d
tumbler113412823tumble_r
tummies113012033tummie_s
tummlers12295703tummlers
tumoral938133tumoral_
tumorous1046603tumorous
tumors8810613tumor__s
tunnels7328723tu_nnels
turrets73010673tu_rrets
tutoress845093tutoress
tuyeres10417793tuyere_s
tymbals14265723tymb_als
umbel93612843_umb_el_
umbers104215213_umb_ers
umbles103817493_umble_s
umbral1038633_umbral_
umbras1038643_umbr_as
umbrella1243273_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.406440125.6
2DLD Change Limit146162916.51622431.2
3Display Results91910.0303033.3
 (SQL Overall)178691916.95225703.5
 
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.