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

132 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
arrival103756(None) 
arrivals1145931arrivals
aerial64625712aeri_al
archival1645782archival
archrival1743382archrival
arrayal1055842arrayal
arrhizal2042952arrhizal
arriba867682arriba_
arrive91311792arriv_e
arrived11127352arrived
arriver10117792arriver
arrives101311512arrives
arval86017012a_r_val
atrial65418942atri_al
carnival1345612carnival
corrival1346152corrival
rival85216502__rival
warrigal1244312warrigal
achiral12109183achiral
actinal9312293actinal
admiral1046363admiral
adrenal838263adrenal
aecial84817313aeci_al
aerials74017553aeri_als
aestival1145483aestival
affinal1336443affinal
affixal2043763affixal
agria65517143agri_a_
agrias74315393agri_as
ajiva1586803a_jiva_
ajivas1655133a_jivas
albinal937813albinal
amrita8411133amrita_
amritas939093amritas
anginal8310163anginal
animal85016253a_nimal
aortal65217513aor_tal
apical10913903a_pical
approval1544483approval
apsidal1046703apsidal
arbitral1045423arbitral
archrivals1852363archrivals
areal55928733a_r_eal
argal65023393a_r_gal
argil65116883argi__l
aria46245423a_ri_a_
arias55438023a_ri_as
ariel55228973a_ri_el
aril45843023a_ri__l
armilla936993armilla
armorial1049453armori_al
arnica8310443arnica_
arnicas939543arnicas
arousal748633arousal
arras55626133arr__as
array86317143arr__ay
arrayals1154483arrayals
arrear6310253arr_ear
arris56824683arri__s
arrises71617583arrises
arrivers11137003arrivers
arriving1237363arriving
arroba898663arroba_
arrobas969213arrobas
arsenal739383arsenal
artal55525473a_r_tal
arterial8313633arteri_al
artisan759463artisan
atria56022343atri_a_
audial7312993audi_al
aural54428963aur__al
auroral7310473auroral
axial124515193a_xi_al
barbital1247053barbital
bridal9511453_bridal
burial84117623buri_al
cardinal1139563cardinal
carinal94318233carinal
carnivals1444493carnivals
corrivals1444613corrivals
curial84019153curi_al
datival1135583datival
deprival1444603deprival
drivel105110383_drivel
estival1036323estival
farcical1546953farcical
ferial94621253feri_al
frivol1235113_frivol
harridan12145123harridan
iatrical1049273iatrical
irreal657833irr_eal
lacrimal1244443lacrimal
larrigan944213larrigan
larval948503lar_val
lyrical1236493lyrical
madrigal121627253madrigal
marginal1137603marginal
marital92314183marital
martial92415413marti_al
narial6317953nari_al
nival84915773__nival
nonrival1146623nonrival
ogival1035873_ogival
orbital936923orbital
ordinal838633ordinal
outrival1145323outrival
parral85517533parr__al
partial92616263parti_al
primal104014623_primal
racial83419243raci_al
radial74020393radi_al
radical103312793radical
revival1337033revival
rhinal9510193_rhinal
rial45938093__ri_al
rivals94213183__rivals
riyal84413433__riyal
scribal1137963scribal
serial64625863seri_al
serval93913413ser_val
shrieval1443363shrieval
shrivel13479403shrivel
survival1443923survival
trial54926353_tri_al
tribal8611133_tribal
trinal6516963_trinal
trivial1038713_trivial
turrical1046203turrical
urial54823023_uri_al
urinal6614123_urinal
warragal1243863warragal
warrigals1343773warrigals

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.500357382.0
2DLD Change Limit1340271326.97019229.1
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.51623774.7
 
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.