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

137 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
acrasins103997(None) 
acrasias1048891acrasias
acrasin9311221acrasin_
abrasions1145802abrasions
acrasia9310032acrasi_a
carabins12312352carabins
crasis85020472_crasi_s
abasias9711013a_basias
abasing10610673a_basing
abrading1239503abrading
abrasion1046623abrasion
abrasive1345753abrasive
abrasives1444063abrasives
abrosias1049033abrosias
acacias11510393ac_acias
acariasis1144813acariasi_s
acarids105312243ac_arids
acarine9316003ac_arine
acarines10314343ac_arines
accusing1336783accusing
acetins9313173ac_etins
acridine1139553acridine
acridines1247723acridines
acrogens1147243acrogens
acroleins1145533acroleins
across8312643acros__s
acrostics1346983acrostics
acrylics1584363acrylics
actins86321103ac__tins
acyloins1345893acyloins
aerating92820993aerating
aerations9317903aerations
agrarians1045793agrarians
alanins7315803a_lanins
aliasing9310073aliasing
aliasings1043653aliasings
anchusins1444533anchusins
aphasias132710433aphasias
aphasics15257233aphasics
aplasias10279233aplasias
apraxias1746333apraxias
aramids102810503a_ramids
arcadians1245083arcadians
arcadias1149153arcadias
arcading1239763arcading
arcadings1354383arcadings
arcsine94512393a_rcsine
arcsines104010343a_rcsines
arising83619973a_rising
arraigns944343arraigns
arrases71214543arras_es
arraying1238743arraying
arshins10312573a_rshins
arsine64021043a_r_sine
arsines73518813a_r_sines
arsino64113513a_r_sino
arsis55722423a_r_si_s
arsons63917213a_r_sons
assassins843923assassins
astasias8410143astasias
atrazine1748403atrazine
atrazines1846683atrazines
atresias839473atresias
atropins10410493atropins
attains7310983atta_ins
basins85722763__basins
brains85125473_bra_ins
brasils9410973_brasils
cabins104418913_c_abins
cains75334303_c_a_ins
canakins142010463canakins
carabids1338183carabids
carabin11313213carabin_
carabine12412383carabine
carabines13311463carabines
caravans1338613caravans
carlins93921913car_lins
carotins102315583carotins
caseins93115053_c_aseins
casing94829103_c_asing
casings104013513_c_asings
casini84615863_c_asini
casino84317553_c_asino
casinos93512833_c_asinos
ceasing104118263_ceasing
ceratins102818723ceratins
chains114819703_cha_ins
chasing133715893_chasing
chasings14318253_chasings
cousins9516003_cousins
craning103620303_craning
craping124018713_craping
crases85532313_cras_es
crashes124618403_crashes
crashing143512633_crashing
crass76328043_cras__s
crating103725203_crating
cratons94316033_cratons
cravens124010113_cravens
craving134015733_craving
cravings14428213_cravings
crayons12439233_crayons
crazies183413853_crazies
crazing193914583_crazing
creasing113314443_creasing
creatins103617513_creatins
cretins93216423_cretins
crisis83716343_crisi_s
cyanins122910013_cyanins
cycasins1545283cycasins
drains73719403_dra_ins
ectasis9249613ectasi_s
erasing8317953_erasing
erasions8310983_erasions
gradins93416233_gradins
grains74223093_gra_ins
gratins84119183_gratins
keratins122313473keratins
moccasins1543233moccasins
occasions1344053occasions
phrasing1438013phrasing
phrasings1544323phrasings
rains55140233__ra_ins
raisins72715343__raisins
rasing74330833__rasing
ravins94622563__ravins
rawins95617623__rawins
resins64528773__resins
rosins64521863__rosins
safranins1244353safranins
sasins64923103__sasins
scrapies124612473scrapies
scraping133310863scraping
scrapings14255163scrapings
sprains93013593spra_ins
strains74218153stra_ins
trains64725343_tra_ins

Search took 9 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.1731032896.0
2DLD Change Limit1461621378.56317069.0
3Display Results1371370.1101245.5
 (SQL Overall)1786911378.84620200.2
 
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.