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

253 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
argali7501375(None) 
argal65023391argal_
argala74712671argala
argalis84214191argalis
argals75517711argals
algal66518222algal_
alkali10127562alkali
areal55928732areal_
argalas84011092argalas
argil65116882argil_
argils75213622argils
argle65421562arg_le
argol65317262argol_
argols74514612argols
argyle1066062argyle
argyll1033642argyll
artal55525472artal_
arval86017012arval_
aal39058673a__al_
aalii5316133a__alii
aals49941143a__als
abaci94718843a_baci
abigail1044193abigail
acari75020283a_cari
aerial64625713aerial_
aerials74017553aerials
afghani1442533afghani
aga410447233a_ga__
again65218123a_gain
agama85815583a_gama
agamic113110563a_gamic
agamid103710693a_gamid
agapai9456863a_gapai
agape85614843a_gape
agar58726413a_ga_r
agaric93513633a_garic
agars66120643a_gars
agas55938843a_ga_s
agate66525153a_gate
agave95314033a_gave
agaze156113663a_gaze
aggada955223aggada
aggadic1254813aggadic
agile65122263a_gile
agly86821803a_g_ly
agnail739533agnail
agrafe1038093agrafe
agravic1345893agravic
aioli5318313a_ioli
airmail946213airmail
alfaki1385383alfaki
alga57927603alga__
algae65319623alga_e
algas65624933alga_s
alkalic13146973alkalic
alkalin11178183alkalin
alkalis11148793alkalis
ambari103012173ambari
anal48037523a_nal_
anga56831353anga__
angaria8311583angaria
angary10311323angary
angas65827983anga_s
angel65019563angel_
angelic1039623angelic
angels74416173angels
angle64528873ang_le
anglo65215373ang_lo
annal56520763annal_
annals66415923annals
annuli6459053annuli
aortal65217513aortal_
appal95315223appal_
appall10379743appall
appals104812943appals
arabic10312733ar_abic
arable81821003arable
arak86929573ar_a_k
araks94820883ar_aks
arame75026623ar_ame
aramid93315613ar_amid
arbalist10313333arbalist
arcade91013643arcade
arcadia1039703arcadia
arcana8912583arcana
arcane81216743arcane
archil11611573archil
archly1437353archly
area45843393area__
areae55229743area_e
areally10411243areally
areas55935773area_s
areola6813673areola
areole61017283areole
argent74023663argent
argled85314553argled
argles75218483argles
argling92812733arg_ling
argon65520593arg_on
argons75018203argons
argosy1036423argosy
argot67728653arg_ot
argotic10310283argotic
argots74116033argots
arguable1135903arguable
arguably1444503arguably
argue64818443arg_ue
argued84311173argued
arguer74510543arguer
argues74516413argues
argufy1344093argufy
argus66716543arg_us
argyles1136053argyles
argylls1143463argylls
arhat8327093arha_t
arhats9312973arhats
aria46245423aria__
ariary94114203ariary
arias55438023aria_s
aridly105513703aridly
ariel55228973ariel_
ariels65119373ariels
aril45843023ar_il_
arils58732203ar_ils
ariosi64313033ariosi
armada938783armada
arrack121110253arrack
arrant6623253arrant
arras55626133arra_s
array86317143arra_y
arrays95311683arrays
artel56122743artel_
artels66216233artels
artily92814713artily
arugola844353arugola
arugula843913arugula
aryl75922343ar_yl_
aryls87015813ar_yls
assai5711543assa_i
assail6610153assail
astragali1053283astragali
atrial65418943atrial_
aural54428963aural_
avail8313883a_vail
avgas96912133avga_s
axal116520493a_xal_
axial124515193axial_
barbal104016663barbal_
bargain1079063bargain
begall92610723begall
biali73419073_biali
brail75525553br_ail
bravi104715753br_avi
carnal83919203carnal_
caroli85918233car_oli
carpal103716253carpal_
carpale113414353carpale
carpalia1247253carpalia
carpals113414623carpals
craal74117753craal_
craals84113303craals
degami10279013degami
drail65020973dr_ail
egal55119433_egal_
ergate7315143ergate
farfal123410183farfal_
farfals13268503farfals
frail85220213fr_ail
frugal1036393frugal_
fugal95613033fugal_
gadi66329723__gadi
gal46055513__gal_
gala55635163__gala
gale56347323__gale
gall56335993__gall
gals57946503__gals
gardai839663garda_i
gargle84215463garg_le
graal64316503graal_
graals74112913graals
grail64622873gr_ail
hartal9415473hartal_
hartals10313023hartals
hegari1039523hegari
jugal135612403jugal_
kraal94511823kraal_
kraals10378433kraals
laogai735983laoga_i
largely1136703largely
larval948503larval_
legal65715943legal_
legals73412733legals
margaric1346063margaric
margarin1148073margarin
margay12310593marga_y
margays1337493margays
marsala939583marsala
nargile847653nargile
narial6317953narial_
narwal938943narwal_
narwals1036983narwals
oorali6311263oorali
oral47638123or_al_
orals55826483or_als
organ6915393orga_n
organa789213organa
organic1038313organic
organs7912913organs
orgasm966303orgasm
origami1045453origami
parral85517533parral_
parrals94414573parrals
priapi1037923priapi
raga55930813raga__
ragas65326063raga_s
raggle83712883raggle
ragi56032283_r_agi
raglan73711503raglan
rai37658223_r_a_i
rail46147763_r_ail
raki87127833_r_aki
rale45050563_r_ale
ramal74622243ramal_
rami66034093_r_ami
rani46640113_r_ani
ratal55025113ratal_
ratals64219583ratals
real45750293_real_
realia6314593_realia
realm75621623_realm
reals55038653_reals
regal65023793regal_
regale74821453regale
regalia839223regalia
reguli738143reguli
rial45938093_rial_
rials55026673_rials
rugal65916093rugal_
tali46837163__tali
tarnal63716503tarnal_
tarsal63315273tarsal_
tarsals72512603tarsals
tergal72912833tergal_
tragi64717173tr_agi
trail55126773tr_ail
trial54926353trial_
trials64319883trials
uraei53016083ur_aei
urari54619963ur_ari
ureal56722683ureal_
urial54823023urial_
urials64415193urials
vagal94613633vagal_

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162534.89323036.2
3Display Results2532530.0763328.9
 (SQL Overall)1786912535.34233450.2
 
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.