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

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

134 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
basaltes1036768(None) 
basalts9358961basalt_s
basalt83519582basalt__
basaltic1245152basaltic
bastes85330382bas__tes
abates85825033_aba_tes
ablates92416903abla_tes
absolutes1144523absolutes
absolves1344413absolves
agates76121343_aga_tes
alates64833963_ala_tes
analytes11169203_analytes
ascites9312603_ascites
baals76122703ba_al__s
baases85218013ba_a_ses
babbles104416323babbl_es
bacalaos1245863bacalaos
badasses1136173badasses
baffles153710683baffl_es
bagasses1136313bagasses
bailees93914383ba_ilees
bailies94120203ba_ilies
bakelites1545993bakelites
balances1279973balances
balases93815433bala_ses
balatas9311833bala_tas
bales76250083b__al_es
ballades114211643ballades
ballets93719513ba_llets
ballies93725743ba_llies
ballutes1037523ballutes
banalities1249813banalities
banalizes201210093banalizes
bangles103617413bangl_es
barflies1338303barflies
barites94322333ba_rites
barytes124611153ba_rytes
basal75722283basal___
basally1237963basal_ly
basaltine1144713basaltine
bascules1236683bascules
baseless1099563baseless
baselines1138603baselines
baseplates14114403baseplates
bases75644353bas___es
bashes115631393bas__hes
bashlyks2041973bashlyks
basifies13310493basifies
basils85717473basil__s
basinets1039063basinets
baskets135111833basket_s
basmatis1247343basmatis
basques18248673bas_ques
basses85428303bas__ses
basseted1136743basseted
bassets96414823basset_s
bassetts10407373bassetts
baste74829983bas__te_
basted95227233bas__ted
baster85333593bas__ter
basters94930303bas__ters
bastiles10313353bastiles
bastilles1147353bastilles
basts75936933bas__t_s
bates75846343b__a_tes
batistes1039713batistes
battles94517683battl_es
baubles113611863baubl_es
bauxites1735153bauxites
behalves1644083behalves
berates94126873bera_tes
bialies93618413b_ialies
bivalves1643383bivalves
borates94823013bora_tes
bubales113513343bubal_es
bustles93816323bustl_es
carates95630613cara_tes
caseates10313713caseates
casettes1039653casettes
castes85631863cas__tes
castles94917733castl_es
casualties1244753casualties
cataloes10311653cataloes
desalted1038313desalted
desalter938363desalter
desalters1037673desalters
desalts839573desalt_s
fayalites1546063fayalites
gallates92815523gallates
gasalier936443gasalier
gasaliers1044513gasaliers
hamates122917683hama_tes
haslets102510863has_lets
hassles103411693hassl_es
hastes95727073has__tes
jacales16310323jacal_es
karates115617473kara_tes
lasagnes944783lasagnes
lysates10317473lysa_tes
malates93522603mala_tes
masalas9312053masal_as
misalter1038343misalter
misalters1136913misalters
nasalise848863nasalise
nasalises948113nasalises
nasalities1048563nasalities
nasalizes1847233nasalizes
nasals63312463nasal__s
palates93624933pala_tes
pastes85233913pas__tes
psalter9247813_psalter
psalters10227713_psalters
rassles73513923rassl_es
resales74724903resal_es
resalutes947433resalutes
reslates83619503reslates
sales56055593__sal_es
salted74121203__salted
salter64325083__salter
salters73622253__salters
saltest71916513__saltest
salties73725773__salties
salts55431883__salt_s
salutes73716253__salutes
salves94221763__salves
sates54949323__sa_tes
sautes63924913__sautes
savates10312953sava_tes
slates64934063__slates
tamales93216153tamal_es
tastes64126423tas__tes
unsalted9510923unsalted
vacates12312833vaca_tes
wastes96224883was__tes

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621346.43622710.1
3Display Results1341340.0632127.0
 (SQL Overall)1786911346.92225814.9
 
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.