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

331 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
acarines1031434(None) 
acarine9316001acarine_
acariases1146612acariases
acarids105312242acari_ds
alanines8314792alanines
amarones10311352amarones
ascarides12346952ascarides
atabrines1144462atabrines
avarices1337182avarices
canines93724032_canines
carbines123617532_carbines
caribes113715642_caribes
carices114220952_carices
caries85147622_cari_es
carinas93622382_carinas
carlines103521642_carlines
carmines123617862_carmines
carnies94123962_carnies
marines93928012_marines
ocarinas1036702ocarinas
scariness11310182scariness
tacrines10310562tac_rines
abalones1038753abalones
abatises10311013abatises
acacias11510393acaci_as
academes1344873academes
acapnias1255683acapnias
acarbose1244683acarbose
acarboses1345083acarboses
acari75020283acari___
acariasis1144813acariasis
acaricides1543943acaricides
acarid95017063acari__d
acaridan1165233acaridan
acaridans1254033acaridans
acarpous1245313acarpous
acarus8312193acar__us
acauline1046903acauline_
accretes1238113accretes
accrues1135323accr_ues
acetins9313173acetin_s
acetones10310033acetones
achenes12313493ac_henes
achiness1339703ac_hiness
acinus8311253ac__inus
acnes75922623ac___nes
aconites10314343aconites
acorned10238263acor_ned
acorns85013013acor_n_s
acquires1945403acquires
acrasins1039973acrasin_s
acres76327763ac_r__es
acrider1038623ac_rider
acridest1138143ac_ridest
acridines1247723acridines
acridness1245073ac_ridness
actings104512463ac_tings
actins86321103ac_tin_s
actives12311523ac_tives
actuaries1147563actuari_es
adenines9310193adenines
aeries64737783a_eri_es
affines1339483a_ffines
agarics10319943agari_cs
agaroses938823agaroses
agatizes1838863agatizes
airiness8412213a_iriness
airings83913833a_irings
airlines8312793airlines
alanine7316863alanine_
alanins7315803alanin_s
alcaides11117673alca_ides
aldrins8310203aldrin_s
alexines15258503alexines
algerines1069083algerines
alines65735223__alines
alizarines1944663alizarines
alkines114415733a_lkines
alpines94016193a_lpines
alumines10411673alumines
amarone9311193amarone_
ambaries123312353ambari_es
ambries111614543ambri_es
amidines113010853amidines
amines84727983__amines
ammines11312673a_mmines
angaries9314383angari_es
angriness1036453angriness
anilines8415133anilines
anserines9411293anserines
apartness1146053apartness
apatites10311283apatites
aperies9423203aperi_es
apiaries10312713apiari_es
apprises12310963apprises
apprizes2137793apprizes
arabizes1969103arabizes
arcadings1354383arcadings
archines133815253archines
arcsines104010343arcsines
arenes64928393__arenes
arises65233803__arises
arrises71617583a_rrises
arrives101311513a_rrives
arsines73518813a_rsines
ascariases1244233ascariases
ascarids11438503ascari_ds
ascaris93613323ascari__s
ascribes1246193ascribes
astatines9310343astatines
astringes1038333astringes
atabrine1045203atabrine_
ataxies142410013ataxi_es
atrazines1846683atrazines
attrites8311563attrites
avarice1238033avarice_
aviaries1139773aviari_es
awardees1243993awardees
awareness1236343awareness
azines155517073__azines
azurites1737283azurites
barites94322333_barites
bearings113912243bearings
brines85028853__brines
cabined1239993_cabined
cabinet11318903_cabinet
cabinets1238283_cabinets
cabins104418923_cabin_s
caginess11310303_caginess
cains75334303_ca_in_s
cairned1037643_cairned
cairns85313303_cairn_s
cajones163311333_cajones
cakiness1449553_cakiness
calamines13312203calamines
calcines12314753calcines
calices114321693_calices
camises114218463_camises
canaries10318943canari_es
canes75350373_ca__nes
canine83826703_canine_
capizes20410373_capizes
caprices1439893caprices
caprine11314233caprine_
carabines13311463carabines
carafes125015703_carafes
carates95630603_carates
carbides133111693_carbides
carbine112918643_carbine_
cardings123812623_cardings
careens94514703_careens
cares77369183_car__es
cargoes104415223_cargoes
caribe103416753_caribe_
caried94528693_cari_ed
carina84325323_carin_a
carinae94318583_carinae
carinal94318223_carinal
caring95137993_carin_g
carioles10817063_carioles
carious93320283_carious
caritas93316943_caritas
carles85435083_car_les
carline93923613_carline_
carlings114015853_carlings
carlins93921913_carlin_s
carmine112918483_carmine_
carnet84732873_car_net
carnets93918403_car_nets
carney115315703_car_ney
carneys124310543_car_neys
carnie84421093_carnie_
carns75937563_car_n_s
carpings133812383_carpings
carries94328013_carries
carses85233653_car_ses
cartes86239473_car_tes
carves115128453_car_ves
carvings143810203_carvings
casings104013513_casings
casinos93512833_casinos
cassines103116613cassines
cavies114525003_cavi_es
cavings134712543_cavings
cerises94722253_cerises
cerites94823433_cerites
chaines124518733_chaines
chariness14310063chariness
chines115029173_c_hines
chorines132917253chorines
cines75239683_c__ines
citrines102513133citrines
claries93422203clari_es
clarinet10317293clarinet
clarinets1137683clarinets
clines84926043_c_lines
cocaines121314443coca_ines
conines93827793_conines
cosines94122673_cosines
cranes84330753_c_ranes
cries75438403_c_ri_es
crimes105521583_c_rimes
cringes103215503_c_ringes
cripes105120873_c_ripes
crises84529433_c_rises
crones84729243_c_rones
curarines11710543curarines
curies84934023_curi_es
curites93919863_curites
cyanines132710543cyanines
czarinas1935293czarinas
darings93713643_darings
dataries9314033datari_es
dearies83526273deari_es
diamines11311623diamines
diaries83321953diari_es
diazines1838703diazines
doctrines1247153doctrines
dourines9311363dourines
earings84517703_earings
ecartes94212563ecar_tes
eccrine1137283eccrine_
enamines101112103enamines
eserines8413743eserines
etamines101611793etamines
eucaines1038503euca_ines
examines17128773examines
famines123216263_famines
farinas103215233_farinas
flamines13311623flamines
flavines1437893flavines
gabardines1443073gabardines
gamines103618463_gamines
gearings10359493gearings
glariness1038553glariness
gradines103615253gradines
guanines989773guanines
harmines132715133_harmines
hearings123611843hearings
hoariness1238823hoariness
hyalines14169323hyalines
imagines1137463imagines
isatines8310663isatines
jarinas143712183_jarinas
larine63927043_larine_
latrines8515003latrines
lawines103313563_lawines
lucarnes1045093lucar_nes
macaronies1446173macaronies
macaronis1346563macaronis
machines15312883mac_hines
magazines2145633magazines
malines93625603_malines
margarines1347193margarines
marinas93519373_marinas
marine84230403_marine_
mariner93315993_mariner
mariners103113863_mariners
marlines103818713_marlines
moraines10314343moraines
murines93718223_murines
muscarines1445393muscarines
narine63422553_narine_
nectarines1246883nectarines
neurines8311193neurines
ocarina948023ocarin_a
opalines10311423opalines
ovaries10312653ovari_es
oxazines2434073oxazines
palatines11313013palatines
paries84742513_pari_es
parings104219213_parings
parises94827183_parises
patines95225763_patines
pralines102217723pralines
purines94420763_purines
rapines95120863_rapines
ratines75328583_ratines
ravines104220233_ravines
roarings9248283roarings
sabines94318483_sabines
sacrings11278923sac_rings
salaries8319573salari_es
salines74029413_salines
sardines92815563_sardines
sarins63932623_sarin_s
savarins1139893savarin_s
savines104417633_savines
scabies11613333scabi_es
scaliness1149303scaliness
scares85033003scar__es
scarier94017873scari_er
scariest101615943scari_est
scarifies1439603scarifies
scaring103421973scarin_g
scariose1037593scariose
scarious10610203scarious
scarves124511623scar_ves
sciurines1144683sciurines
scribes113713203sc_ribes
scries85226823sc_ri_es
scrives124414273sc_rives
serines74229543_serines
shrines104618693_shrines
soarings93210393soarings
stanines85115663stanines
stearines9311283stearines
sycamines1645513sycamines
taborines11238963taborines
tacrine9311293tac_rine_
tamarinds1244163tamarinds
tamarins10310833tamarin_s
taurines8310543taurines
teariness9310633teariness
terrines82117523terrines
trines64132563__trines
tsarinas835273tsarinas
tzarinas1733973tzarinas
urines64724123__urines
vaccines1536503vac_cines
vagaries12310293vagari_es
vahines133410523_vahines
valines104520213_valines
varices123313573_varices
varies94330873_vari_es
vitrines112610913vitrines
wahines133111173_wahines
wariness11313213_wariness
wearies103020223weari_es
weariness1238843weariness
zebrines1935883zebrines

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.1561145455.1
2DLD Change Limit1461623317.51619446.8
3Display Results3313310.1232691.1
 (SQL Overall)1786913317.79522923.8
 
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.