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 “tumbles” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
tumbles11381602(None) 
bumbles134016841bumbles
fumbles143514411fumbles
humbles143215801humbles
jumbles183013321jumbles
mumbles133014431mumbles
numbles113814271numbles
rumbles114018391rumbles
stumbles1237491stumbles
tumble103215641tumble_
tumbled123412241tumbled
tumbler113412821tumbler
tumblers123110621tumblers
umbles103817491_umbles
ambles105121862_ambles
bubbles104315962bubbles
bumble124216892bumble_
bumbled144113042bumbled
bumbler134013232bumbler
bumblers143710732bumblers
burbles114916802burbles
crumbles14329682crumbles
drumbles13277722drumbles
fimbles143510662fimbles
fumble133214262fumble_
fumbled153710492fumbled
fumbler143610812fumbler
fumblers15318712fumblers
gambles124016202gambles
grumbles13288872grumbles
humble133615052humble_
humbled153711812humbled
humbler143411942humbler
humblers15379802humblers
humblest15288282humblest
jumble174012652jumble_
jumbled19379962jumbled
jumbler183910272jumbler
jumblers19358322jumblers
mumble123614342mumble_
mumbled143010762mumbled
mumbler133510912mumbler
mumblers14328762mumblers
nombles113212342nombles
nubbles113412432nubbles
rambles113118312rambles
rubbles113715112rubbles
rubles83921702ru_bles
rumble103718812rumble_
rumbled124514592rumbled
rumbler113514112rumbler
rumblers123610742rumblers
rumples113313132rumples
scumbles1447022scumbles
stubbles1236842stubbles
stumble1147552stumble_
stumbled1335622stumbled
stumbler1235812stumbler
stumblers1334382stumblers
tables84524892t_ables
tamales93216152tamales
temples112610892temples
thimbles1536022thimbles
thumbless1643432thumbless
timbales12227842timbales
timbres11249352timbres
tombless1236782tombless
trebles9311442trebles
trembles1237352trembles
tubes74826452tu_b_es
tubules9310232tubules
tuilles72411922tuilles
tules54532792tu__les
tulles63218892tu_lles
tumbleset1345372tumbleset
tumbrel11406852tumbrel
tumbrels12285732tumbrels
tummies113012032tummies
tummler11266612tummler
tummlers12295702tummlers
tumults934822tumults
tumulus935032tumulus
turtles72914342turtles
tussles737832tussles
umbels104510592_umbels
wambles143714022wambles
wimbles143010852wimbles

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671873.37331921.4
3Display Results87870.0332636.4
 (SQL Overall)178691873.78247247.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.