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

248 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
archines13381525(None) 
archine125817051archine_
archings14499861archings
archives16399551archives
arcsines104010341arcsines
achenes12313492a_chenes
achiness1339702a_chiness
archaises1448402archaises
archaizes2346442archaizes
arches114822042arch__es
archfoes1644992archfoes
archils12510532archi_ls
arching136216692archin_g
archive154610482archive_
archived17355992archived
archness1337512arch_ness
archons12311582archon_s
arcsine94512392arcsine_
arshins10312572arshin_s
arsines73518812ar_sines
chines115029172__chines
errhines1136412errhines
machines15312892machines
narceines1146582narceines
orchises1338772orchises
rachides141511222rachides
rachises131412412rachises
urchins1238862urchin_s
acarines10314343acarines
achene11313813a_chene_
aches106132293a_ch__es
achier113914263a_chi_er
achiest12315183a_chi_est
achieves1645523a_chieves
aching126521973a_chin_g
achiotes1339003a_chiotes
acinus8311253a_c_inus
acnes75922623a_c__nes
acridines1247723acridines
actings104512463a_ctings
actins86321103a_ctin_s
actives12311523a_ctives
adenines9310193adenines
affines1339483a_ffines
airlines8312793airlines
alanines8314803alanines
alcaides11117673alcaides
alexines15258503alexines
alines65735223a__lines
alkines114415733a_lkines
alpines94016193a_lpines
alumines10411683alumines
amidines113010853amidines
amines84727983a__mines
ammines11312673a_mmines
anarchies1448183anarchi_es
ancones93116343anc_ones
anilines8415143anilines
aphides134711203a_phides
arabizes1969103arabizes
arachnids1574303arachnids
arcades101113193arc_ades
arcadings1354393arcadings
arcane81216743arc_ane_
arccosines1443163arccosines
archaea12137613arch_aea
archaise1348473archaise_
archaised1545483archaised
archaisms1646073archaisms
archaists1446583archaists
archaize2246213archaize_
archaized2445073archaized
archaizer2344523archaizer
archaizers2443633archaizers
archangel1544313archangel
archangels1643283archangels
archdukes1942563archdukes
arched125717323arch__ed
archenemy1982123archenemy
archer115016243arch__er
archeries14411223archeries
archers124414573arch_ers
archfiend1841933archfiend
archfiends1951483archfiends
archfoe1544723archfoe_
archil11611573archi__l
architect1644683architect
architects1772603architects
archival1645783archival
archivist1745493archivist
archon11311753archon__
archways1944063archways
arcing95819643arc_in_g
arcking145811963arckin_g
arctics1138953arcti_cs
arcuses94814693arc_uses
arecolines1246503arecolines
arenes64928393ar__enes
arenites8917103arenites
arginines1047053arginines
arises65233803ar__ises
armholes1347383armholes
armies85123693ar_mi_es
armings103811503ar_mings
armoires1057623armoires
aroints7313133ar_oints
arrises71617583ar_rises
arrives101311513ar_rives
arshin9312173arshin__
arsine64021043ar_sine_
artiness81615403ar_tiness
artsiness937653artsiness
ascites9312603asc_ites
ascribes1246193ascribes
ashiness1138963a_shiness
atrazines1846683atrazines
atropines1148883atropines
azines155517073a__zines
barchans1588683barchan_s
brines85028853br__ines
bromines122514253bromines
brucines1237763brucines
calcines12314753calc_ines
camphines1847563camphines
carabines13311473carabines
carbines123617533car_bines
carlines103521643car_lines
carmines123617863car_mines
chaines124518733__chaines
chides124620473__chides
chiles115425303__chiles
chimes134922573__chimes
chinas115119403__chinas
chine105231723__chine_
chined125620063__chined
chinks155817573__chinks
chinos115018693__chinos
chins105631463__chin_s
chints115117833__chints
chives144317593__chives
cines75239683__c_ines
clines84926043__clines
cocaines121314443cocaines
cochins141413103cochin_s
croceines1347733croceines
dauphines1544343dauphines
declines113315803declines
diarchies1546753diarchi_es
duchies133312313duchi_es
dyarchies1844033dyarchi_es
earphones1448393earphones
earthiness1377243earthiness
echinus1236203_echinus
eparchies1646973eparchi_es
ermines9416673er_mines
errhine1036593errhine_
etchings14396293etchings
eucaines1038513eucaines
exarchies2145213exarchi_es
farcies125317883farc_i_es
farthings1635233farthings
fascines13310143fasc_ines
fuchsines17103333fuchsines
gradines103615253gradines
harmines132715143har_mines
hatchings18225673hatchings
inclines10313143inclines
itchiness1444753itchiness
itchings14386193itchings
kachinas1736343kachinas
katchinas1843923katchinas
larcenies1147533larcenies
larches124416443larch__es
machine14313493machine_
machined1637303machined
marches143921173march__es
marching164312193marchin_g
marchioness1842733marchioness
marchpanes1943603marchpanes
marines93928013mar__ines
marlines103818713mar_lines
marshiness1555063marshiness
morphines1648233morphines
narceine1046753narceine_
narceins1036413narcein_s
narghiles1343543narghiles
orceins937743orcein_s
orchids1377213orchi_ds
orchils1277703orchi_ls
orchis11710773orchi__s
orchitis1346423orchitis
orcins83313433orc_in_s
ordines83014903or_dines
orpines94414793or_pines
oscines9310363osc_ines
parches143720003parch__es
parching164313053parchin_g
parchisis16318573parchisis
patchiness1744933patchiness
pectines121914683pectines
pralines102217723pralines
primines123013703primines
procaines13311523procaines
prolines102619693prolines
promines123018803promines
propines122618933propines
rachis114017653rachi__s
rachitis1348353rachitis
raciness102413453rac_iness
racings105015133rac_ings
raphides14188393raphides
rapines95120863_rapines
ratines75328583_ratines
ratlines83815293ratlines
ravines104220233_ravines
rawhides15145543rawhides
reclines103718543reclines
refines105426343_refines
rehinges1248403_rehinges
rehires105016113_rehires
relines75331323_relines
repines94927383_repines
reshines112615443reshines
retines75134673_retines
rexines144719153_rexines
rhinos94411123_r_hinos
ruchings14287073ruchings
sarcinas1039273sarc_inas
sardines92815563sar_dines
shines95028913__shines
starchiness1643943starchiness
tacrines10310563tacrines
techies12513603techi_es
trephines1448483trephines
trichinas1446043trichinas
trichites1448883trichites
trines64132563tr__ines
tropines102214923tropines
urchin1138743urchin__
uridines989513uridines
urines64724123ur__ines
vaccines1536503vaccines
vahines133410523_vahines
vichies15310623vichi_es
wahines133111173_wahines
whines125120103__whines
xanthines1966723xanthines
zechins21137123zechin_s

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.420425454.8
2DLD Change Limit1461622486.53322372.9
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.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.