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 “arris” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
arris5682468(None) 
abris75722601abris
arras55626131arras
arsis55722421arsis
auris55331531auris
orris54516551orris
abri65522212abri_
acres76327762acres
acrid86920102acrid
aegis6316782aegis
aerie54634602aerie
aeries64737782aeries
afrit8323172afrit
afrits9311902afrits
agria65517142agria
agrias74315392agrias
ahis76135382a_his
airns55521032airns
airs46447422air_s
airts55626342airts
ais39083572a__is
amirs75924922amirs
amis66445322a_mis
anis45746462a_nis
antis55033312antis
aorist64827872aorist
aphis105917132aphis
apres75426402apres
apsis75718292apsis
araks94820882araks
arbs66834732a_rbs
arcs67834782a_rcs
arcus76918862arcus
areas55935772areas
areic73219392areic
ares45871022a_res
arfs76029962a_rfs
argil65116882argil
argils75213622argils
argus66716542argus
aria46245422a_ria
arias55438022arias
arid57642712a_rid
aril45843022a_ril
arils58732202arils
arise56436432a_rise
arks85936872a_rks
arles56735742arles
armies85123692armies
arms66137492a_rms
aroid65428342aroid
aroids75118222aroids
array86317142array
arrays95311682arrays
arrest63722632arrest
arriba867682arriba
arrises71617582arrises
arrive91311792arrive
arrives101311512arrives
arrow83414882arrow
arrows92813482arrows
ars37670932a_r_s
arses55733872arses
artist64125542artist
arts49650262a_rts
arums75517832arums
arvos86015662arvos
aryls87015812aryls
aspis74618142aspis
atria56022342atria
atrip75315752atrip
auras55932562auras
aures55137092aures
auric74521732auric
aurist65027252aurist
axis116127912a_xis
barres84427542barres
barrio8312572barrio
barrios9310772barrios
bris65539612_bris
capris10415082capris
carries94328012carries
carrs75730852carr_s
cris66233432_cris
derris73615272derris
errs45622532err_s
gharris11306432gharris
harries103525492harries
iris45732552_iris
kauris103611532kauris
kris86423602_kris
laris54737462laris
loris55329152loris
marries93825282marries
morris83814732morris
naris55735292naris
noris54928272noris
ornis54616772ornis
paris75145942paris
parries93925842parries
parrs75928672parr_s
parvis116114802parvis
peris75537072peris
puris75332022puris
ragis66325602ragis
rais45252622_rais
rakis95323442rakis
ranis55235832ranis
rares55247442rares
reis45343232_reis
saris54544952saris
shris84221452shris
sris45434152_sris
tarres64723042tarres
tarries73324262tarries
trois57226092trois
uraris63817272uraris
zoris145320012zoris

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001181.70331591.3
3Display Results1181180.0303933.3
 (SQL Overall)1786911182.04687336.8
 
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.