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

151 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
astatine831353(None) 
astatines9310341astatines
astatic9514192astati_c
estating92614992estating
isatine7311762is_atine
stanine73417072_stanine
statice92614032_statice
statin63921472_statin_
stating83725162_stating
statins73719772_statins
stative102612932_stative
abating10413973a_bating
ablating11312003ablating
ablative1348243ablative
abstain947253absta_in_
abstained1245053absta_ined
abstainer1144403absta_iner
abstains1047323absta_ins
acarine9316003a_carine
actuating1239233actuating
aerating92821003aerating
agatize1739833a_gatize
agitating1138863agitating
agitative1346873agitative
alanine7316863a_lanine
alkaline12168283alkaline
amative12311733a_mative
antimine10714753antimine
apatite9312963a_patite
apostatise1255253apostatise
apostatize2164573apostatize
aquatint1749433aquatint
aquatone1744913aquatone
asbestine1144883asbestine
asinine7310723as_inine
assaying1236003assaying
astasia7310933astasi_a
astasias8410143astasias
astride8311973ast_ride
astringe938223ast_ringe
astute6310763astut__e
atabrine1045203a_tabrine
atrazine1748403atrazine
attain6311753atta_in_
attained997353atta_ined
attainer8116913atta_iner
attains7310983atta_ins
attaint7313473atta_int
attire62412383a_t_tire
attune637983a_t_tune
aviating12311023aviating
basaltine1144713basaltine
betaine9413783beta_ine
caseating12311743caseating
castrating1349773castrating
cavatine13310323cavatine
creatine103417413creatine
enstatite946193enstatite
estaminet1149693estaminet
estate64719763estat__e
estuarine944983estuarine
etamine91313073_etamine
gelatine93213313gelatine
gestating11229983gestating
gestative1347303gestative
gratine84719193_gratine
gustative1345683gustative
hastate10313913hastat__e
hematine131614673hematine
histamine1476903histamine
instating10812213instating
isatin6412213is_atin_
isatines8310663is_atines
isatins7310773is_atins
ketamine14157053ketamine
lactating1239193lactating
legatine91311403legatine
mutating112211753mutating
mutative1348283mutative
notating92513343notating
nutating92411953nutating
nystatin1145093nystatin_
nystatins1244753nystatins
optative1347653optative
palatine10316073palatine
pastalike1546723pastalike
patine85328123__patine
petaline10314883petaline
putative1348373putative
ratine65131823__ratine
restating102319413restating
rotating92614553rotating
rotative11310343rotative
sabine84020393_s_abine
saline65132703_s_aline
saltine75018563_saltine
sanative11310473sanative
satiating10311813satiating
satin55935223_s_atin_
satinet7325283_s_atinet
sating74735453_s_ating
satins64930483_s_atins
satiny93817983_s_atiny
satire63218003_s_atire
savine94220283_s_avine
saxatile1544953saxatile
seating84130683_seating
sestine73017923_sestine
skating123613853_skating
slating83724653_slating
smaltine1037833_smaltine
sonatine8313323sonatine
stabile9312063_stabile
staging93818373_staging
stain55727943_sta_in_
stained84215343_sta_ined
stainer73614923_sta_iner
stains64923653_sta_ins
staithe1037723_staithe
staking123919803_staking
staling83925423_staling
stamina9310793_stamina
stane55933003_sta__ne
stanines85115673_stanines
staning83922243_staning
staring84527053_staring
starting93116173_starting
statant7313123_statant
state56237333_stat__e
static83118683_stati_c
statices102712343_statices
statics93314533_statics
station72717243_station
stationed1046143_stationed
stationer946033_stationer
stations82415223_stations
statism9412283_statism
statist7317723_statist
statives112710793_statives
statue66015323_stat_ue
stature74410683_stature
statute7419323_statute
staving113915703_staving
staying114017323_staying
stearine8311903_stearine
steatite8310583_steatite
stibine938663_stibine
stotin63215063_stotin_
stotins73213873_stotins
unstating10711213unstating
vitamine1347373vitamine

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621516.56022280.8
3Display Results1511510.0801887.5
 (SQL Overall)1786911517.04625360.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.