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

61 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
tumbrils1225537(None) 
tumbrels12285731tumbrels
tumbril11256401tumbril_
gumboils1343892gumboils
nombrils1244512nombrils
timbrels12265342timbrels
tumbrel11406852tumbrel_
ambries111614553_ambries
bulbils11338333bulb_ils
cambrics1645253cambrics
cumarins1238643cumarins
cumbias13338963cumb_ias
cumbrous1446173cumbrous
embroils1245773_embroils
fibrils1236843_fibrils
gambrels1334213gambrels
gomerils1146793gomerils
gumballs1345313gumballs
gumboil1244373gumboil_
gumbotils1451743gumbotils
hubris11218973hu_bri_s
humerals1347173humerals
jumbals18106533jumb_als
lumbricals16112293lumbricals
nombril1145103nombril_
numerals1047333numerals
numerics1266283numerics
rubrics1177093ru_brics
tamarins10310843tamarins
tamaris9413593tamari_s
tendrils946443tendrils
thumbkins2042163thumbkins
thumbnails1751583thumbnails
timbals11239533timb_als
timbral11237193timbral_
timbrel11306563timbrel_
timbres11249353timbr_es
tubfuls1245483tu_bfuls
tughriks1641713tughriks
tugriks1233153tu_griks
tumble103215643tumb__le
tumblers123110623tumblers
tumbles113816023tumb_les
tumbling13219293tumbling
tumblings14184843tumblings
tumefies1345773tumefies
tummies113012033tum_mies
tumoral938133tumoral_
tumorous1046603tumorous
tumors8810613tumor__s
turbaries1147743turbaries
turbits969233turb_its
turmerics1343833turmerics
turmoils1043983turmoils
tutorials945133tutorials
twibils1253113twib_ils
tymbals14265723tymb_als
umbels104510593_umb_els
umbral1038633_umbral_
umbras1038643_umbr_as
upboils1184703_upboils

Search took 8 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.423422437.4
2DLD Change Limit146162617.53019410.6
3Display Results61610.0163812.5
 (SQL Overall)178691617.96922423.3
 
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.