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

95 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
arbutus94484(None) 
arbutes939701arbutes
abuts75417072a_but_s
arbute8311042arbut_e
arbutuses1143722arbutuses
arduous837612arduous
barbuts11439842barbut_s
abacus10349763a_bacus
abates85825033a_bates
abatis84317933a_batis
abbots1039283abbot_s
abets75621673a_bet_s
abortus9397913abortus
abuses85119103a_buses
abut66834953a_but__
acutes83917723a_cutes
agoutis8286873agoutis
airbus848343airb__us
airbuses1067073airbuses
albatas938373albatas
albites9313203albites
albums10198273albu_ms
ambits103713413ambit_s
annulus7426613annulus
arbiter939933arbiter
arbiters1038853arbiters
arbores94016033arbores
arborous1047723arborous
arbors84717883arb_ors
arbour84211333arb_our
arbours93910043arbours
arbs66834733arb___s
arbutean1043003arbutean
arcus76918863ar__cus
arcuses94814693arcuses
arenous7314183arenous
aretes64425353ar_etes
argots74116033argot_s
arguers8489033arguers
argues74516413argu_es
argus66716543ar__gus
arguses84711743arguses
arhats9312973arhat_s
aristas7413523aristas
aristos7312373aristos
armets84918353armet_s
armures9510273armures
arouses74921293arouses
arquebus1942263arquebus
arts49650263ar__t_s
arums75517833ar_u_ms
asbestus1042953asbestus
auburns935573auburns
autos56523323a__utos
barbets114915843barbet_s
barbules1238043barbules
barbut104617003barbut__
brutes86118683br_utes
bruts75922953br_ut_s
bubus95115453__bubus
butes714535873__butes
buts67247693__but_s
butts75824253__butts
butut75522913__butut
bututs8409423__bututs
croutes94815653croutes
cubitus11346783cubitus
debuts93911753debut_s
drouths11436483drouths
earbuds1044633earbu_ds
fractus12146593fractus
grouts75015613grout_s
habitus12338173habitus
hagbuts1354923hagbut_s
krauts10418513kraut_s
krubuts1343013krubut_s
orbits84211443orbit_s
prunus8399363pr_unus
rabatos93010903rabatos
rabats83116223rabat_s
rebuts84015193rebut_s
rectus83314633_rectus
rictus8379193_rictus
routes66129313_routes
rouths95416823_rouths
routs57133413_rout_s
rubus76415063_r_ubus
ruths85714643_r_uths
ruts44541493_r_ut_s
sacbuts1166473sacbut_s
sagbuts1065223sagbut_s
tributes1047233tributes
trouts66116633trout_s
truths9449503tr_uths
tutus55214813__tutus

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.1401276364.3
2DLD Change Limit134027956.89019452.4
3Display Results95950.0332878.8
 (SQL Overall)178691957.06325299.6
 
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.