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

141 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
anatases83979(None) 
anabases1038081anabases
anatase738941anatase_
abatises10311012abatises
anabasis1047372anabasis
analyses11149962analyses
anaphases1446522anaphases
anlases72514902an_lases
entases72816272en_tases
abacuses1235763abacuses
abases85720773__abases
abates85825033abat__es
abattises1155083abattises
acariases1146613acariases
acetates102013063acetates
agaroses938823agaroses
agates76121343agat__es
agatizes1838863agatizes
agitates9310883agitates
agnates82813193agnat__es
alates64833963alat__es
aliases7914493a_liases
amasses93912853ama_sses
amidases1136653amidases
amitoses1039053amitoses
amylases1346663amylases
anabas8314083anaba__s
anabioses1145403anabioses
anaclises1147863anaclises
anacruses1145523anacruses
anagoges10187243anagoges
analyse10208893analyse_
analysed12166913analysed
analyser11166133analyser
analysers12124603analysers
analysis11128293analysis
analysts11167443analysts
analytes11169203analytes
analyzes20157193analyzes
anamneses1144613anamneses
anankes1138763ana_nkes
anapaest1046023anapaest
anapaests1143233anapaests
anapests1046613anapests
anaphase1345463anaphase_
anaptyxes2141903anaptyxes
anatomies11159693anatomies
anatomises1297363anatomises
anattos7138453anat_tos
anemoses10159433anemoses
animates101316423animates
animuses1037983animuses
anises64826693an__ises
ankuses1148203an_kuses
anlaces92313733an_laces
anlages82414113an_lages
annates72415423an_nates
annotates977293annotates
antae56828293an_ta_e_
antas55432033an_ta__s
antes56334323an_t__es
antheses11311473antheses
antisex1439693an_tisex
antres65021003an_t_res
anureses837973anureses
anuses66218773an__uses
apanages1137013apanages
apathies1339003apathies
apatites10311293apatites
appeases1238663appeases
apyrases1337243apyrases
aromatases1245073aromatases
arrases71214543a_rrases
atlases72410643a_tlases
avatars1036443avata_rs
avgases11106313a_vgases
azotises1737603azotises
baases85218013_ba_ases
balases93815433_balases
camases114216343_camases
canalises11515493canalises
canvases13349523can_vases
caritases1139753caritases
catalases1149443catalases
charases131312763charases
databases1243913databases
diabases1137223diabases
diastases1047073diastases
ectases92911673_ectases
elastases946113elastases
enates64026433enat__es
encases93116053en_cases
enchases13310273enchases
enolases8411013enolases
entasis73012573en_tasis
epitases1038933epitases
fantasies1298853fan_tasies
fantasms1345633fan_tasms
fantasts1147113fan_tasts
flatuses1137173flatuses
fracases1336993fracases
guanases936233guanases
hiatuses1135773hiatuses
incases93615973in_cases
instates81615833instates
intakes11310943in_takes
inulases838763inulases
lactases1038513lactases
maltases1039693maltases
manatees10310423manat_ees
mantises10317923man_tises
meatuses1038203meatuses
mutases92012043_mutases
naiades838213_naiades
nates55238333_nat__es
natives10310823_natives
natures7311963_natures
notates72817483_notates
nutates73214973_nutates
nutcases1085793_nutcases
parataxes1846393parataxes
pectases122411193pectases
platanes102711883platanes
protases102115033protases
sanitates9611733sanitates
sanitises91111743sanitises
snatches131410713snatches
snathes104816493snat_hes
stases64225563__stases
statuses8409543statuses
tarantases1044893tarantases
thanatoses1343543thanatoses
unawares1137053unawares
uncases93516553un_cases
uneases73316263un_eases
unitages938273unitages
unstates81314993unstates
vanadates1345133vanadates
vantages12119023van_tages
wantages12109023wan_tages
watapes12228383_watapes

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 Limit1461621416.83021400.0
3Display Results1411410.0602350.0
 (SQL Overall)1786911417.29624491.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.