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

143 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
annuals738819(None) 
annals66415921ann_als
anneals7449941anneals
annual64710701annual_
annuls64711731annu_ls
animals94111702animals
annal56520762ann_al_
annas55824882ann_a_s
anneal64812292anneal_
annually1145832annually
annul55813382annu_l_
annular737692annular
annuli6459052annu_li
annulus7426612annulus
cannulas1037582cannulas
manuals9311212manuals
aals49941143a___als
accruals1243703accruals
accusals12145053accusals
acetals93411353acetals
actual8311023actual_
aerials74017553aerials
agnails837003agnails
ampuls1098893ampu_ls
anabas8314083anaba_s
anal48037523a_n_al_
anas46649863a_n_a_s
anears63717183a_nears
angas65827983a_nga_s
angels74416173a_ngels
angular838533angular
anils56326723a_n_ils
animal85016253animal_
animas84418723anima_s
ankus91410683anku__s
ankuses1148203ankuses
anlas55626933a_nla_s
anna45529013ann_a__
annalist8413753ann_alist
annates72415423annates
annealed936323annealed
annealer845503annealer
annealers944563annealers
annexes1437203annexes
annonas738793annonas
annoys967523ann_oys
annualize1845613annualize
annualizes1945083annualizes
annuity1045543annuity
annularly1243613annularly
annulate8310923annulate
annulet7311593annulet
annulets845813annulets
annulled944833annulled
annulose844473annulose
anoas57226493a_noa_s
anodal72512113anodal_
anomaly1238843anomaly
anoraks1137603anoraks
antas55432033a_nta_s
antiars7314623antiars
antral65719413antral_
anural65714743anural_
anurans73810553anurans
anus47131113a_nu__s
anuses66218773a_nuses
anvils9219713a_nvils
anyways1644423anyways
apicals1159923apicals
apneal83411123apneal_
apneas83211383apnea_s
appals104812943a_ppals
appeals11378673appeals
aquas142412613a_qua_s
argals75517703a_rgals
arousals866263arousals
astrals75515243astrals
atabals938413atabals
avowals1335013avowals
biannual1043323biannual_
canals84421663can_als
canfuls1248423canfu_ls
cannas84518403cann_a_s
cannels93413363cann_els
cannibals1354443cannibals
cannula937433cannu_la
cannulae1046493cannulae
cannular1046283cannular
cantals93919573cantals
canulas9312853canulas
casuals91410523casuals
centals94317053centals
denials84114133denials
dentals83915393dentals
duals65620083__duals
enneads834733enneads
ennuis636473ennu_is
equals1538693_equals
finals94316163fin_als
finials103210153finials
fungals11276783fungals
gingals9109303gingals
inhauls1035513inhauls
instals7611713instals
jingals1588063jingals
jouals1338923_jouals
knurls10396243_knurls
lanitals837723lanitals
linguals9317213linguals
mannans93611523mann_ans
mannas85019803mann_a_s
mantuas93410993mantua_s
manual8313463manual_
menials94015683menials
mutuals937123mutuals
nanas55928633nan_a_s
narwals1036983narwals
nasals63312463_nasals
naturals847903naturals
nopals84914023_nopals
nulls55019983__nulls
nurls55519683__nurls
panfuls1237173panfu_ls
pineals93212843pineals
ranulas7311773ranulas
rentals74017473rentals
rituals738353rituals
sandals82715203sandals
sannups934463sannu_ps
sendals81912263sendals
tincals93610633tincals
uncials92510523uncials
uncurls937123uncurls
unequals1743723unequals
unfurls1035573unfurls
ungual738183ungual_
unnails738223unnails
unseals73212573unseals
usuals637783_usuals
vandals113211663vandals
vinals94716483vin_als
visuals1036853visuals
zonulas1637023zonulas

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.1601116818.8
2DLD Change Limit1340271437.29618369.9
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.50223819.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.