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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
rumbles11401839(None) 
bumbles134016841bumbles
crumbles14329681crumbles
drumbles13277721drumbles
fumbles143514411fumbles
grumbles13288871grumbles
humbles143215801humbles
jumbles183013321jumbles
mumbles133014431mumbles
numbles113814271numbles
rambles113118311rambles
rubbles113715111rubbles
rubles83921701ru_bles
rumble103718811rumble_
rumbled124514591rumbled
rumbler113514111rumbler
rumblers123610741rumblers
rumples113313131rumples
tumbles113816021tumbles
umbles103817481_umbles
ambles105121852_ambles
brambles14308972brambles
brumbies1436532brumbies
bubbles104315962bubbles
bumble124216892bumble_
bumbled144113042bumbled
bumbler134013232bumbler
bumblers143710732bumblers
burbles114916802burbles
crumble133410402crumble_
crumbled15357442crumbled
crumples14348812crumples
drumble12337892drumble_
drumbled14266032drumbled
fimbles143510652fimbles
fumble133214262fumble_
fumbled153710492fumbled
fumbler143610812fumbler
fumblers15318712fumblers
gambles124016202gambles
grumble12349232grumble_
grumbled14256752grumbled
grumbler13866682grumbler
grumblers14245022grumblers
humble133615052humble_
humbled153711812humbled
humbler143411942humbler
humblers15379802humblers
humblest15288282humblest
jumble174012652jumble_
jumbled19379962jumbled
jumbler183910272jumbler
jumblers19358322jumblers
mumble123614342mumble_
mumbled143010762mumbled
mumbler133510912mumbler
mumblers14328762mumblers
nombles113212342nombles
nubbles113412432nubbles
rabbles113517972rabbles
ramblas112710262ramblas
ramble104519972ramble_
rambled123913512rambled
rambler113313262rambler
ramblers124010372ramblers
rimples113114222rimples
robles85321692r_obles
roubles93413502roubles
rubbies114114112rubbies
rubble104315672rubble_
rubbled124611622rubbled
rubels84112992ru_bels
rubes74928412ru_b_es
rubies84420332ru_bies
ruble74521252ru_ble_
ruckles133414602ruckles
ruddles92813872ruddles
ruffles133512262ruffles
rugbies10339352rugbies
rules55234252ru__les
rumbaed12287492rumbaed
rumbas102512012rumb_as
rumbly134412162rumbl_y
rummies113212792rummies
rumple103913012rumple_
rumpled123810012rumpled
rumpless12256542rumpless
rundles83214712rundles
runkles114111942runkles
rustles73416412rustles
rutiles74315842rutiles
scumbles1447022scumbles
stumbles1237492stumbles
trembles1237352trembles
tumble103215642tumble_
tumbled123412242tumbled
tumbler113412822tumbler
tumblers123110622tumblers
umbels104510582_umbels
wambles143714022wambles
wimbles143010842wimbles

Search took 5 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.1231452772.4
2DLD Change Limit1076711013.95327237.8
3Display Results1011010.0333060.6
 (SQL Overall)1786911014.10943487.7
 
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.