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

29 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
rubberiest144439(None) 
robberies13107392robberies_
rubberier1344392rubberie_r
rubberizes23133822rubberizes_
rubbliest1354682rubb_liest
beeriest104013403__beeriest
bibberies1297133bibberies_
bobberies12107893bobberies_
bubbliest1254413bubb_liest
butteriest1276883butteriest
grubbiest1434253grubb__iest
jobberies20115423jobberies_
nubbiest12117303nubb__iest
nubbliest1354353nubb_liest
puckeriest1843823puckeriest
ribbiest1237583ribb__iest
rubbered1335383rubber_e_d
rubbering1435703rubberi_ng
rubberize22133693rubberi_ze
rubberized24143013rubberized
rubberneck2051393rubberneck
rubbers113913193rubber__s_
rubbies114114113rubb__ies_
rubiest92914423ru_b__iest
ruderies9311333ru_deries_
shrubberies1851963shrubberies_
subseries11312933subseries_
summeriest1476083summeriest
tubbiest12117293tubb__iest

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 Filter1786911406030.186960704.3
2DLD Change Limit140603296.54621479.2
3Display Results29290.0161812.5
 (SQL Overall)178691296.74826480.6
 
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.