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

59 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
robusta94428(None) 
robust8310431robust_
robustas1044351robustas
locusta9326532locusta
robuster1035662robuster
robustly1342762robustly
roust55532062ro_ust_
rousts617016722ro_usts
bobstay1443983bob_stay
bust65947783__bust_
busts75227693__busts
busty105621013__busty
combust1338363combust_
combusts1445503combusts
costa75523733co__sta
frusta937453_frusta
hosta85917833ho__sta
joust125122293jo_ust_
jousts135011273jo_usts
locust85312343locust_
locustae10274713locustae
locustal10325223locustal
locusts9277933locusts
oust46747443_o_ust_
ousts55225703_o_usts
podesta1036763podesta
rebus75721113rebus__
rebuses94915293rebuses
rebut75927383rebu_t_
rebuts84015193rebu_ts
rebuttal1043993rebuttal
roast56230143ro_ast_
roasts64915413ro_asts
robes75133303robes__
robot7325973rob_ot_
robots8313153rob_ots
robs65837873rob_s__
robustest1143973robustest
roost55730933ro_ost_
roosts64916323ro_osts
roquet154415893roquet_
roquets16398943roquets
rostra6310933ro__stra
rota45834343ro___ta
rotunda843943rotunda
rouse56634703ro_us_e
roused75426453ro_used
rouser65224083ro_user
rouses65436283ro_uses
rousted84013333ro_usted
rouster73517083ro_uster
rout46153283ro_u_t_
route55132073ro_u_te
routh86423073ro_u_th
routs57133413ro_u_ts
rubus76415063rubus__
rust45544913r__ust_
rusts55026993r__usts
rusty85221053r__usty

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 Filter1786911340270.406440125.6
2DLD Change Limit134027596.81319672.2
3Display Results59590.0301966.7
 (SQL Overall)178691597.24924650.4
 
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.