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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
arrayal105584(None) 
arrayals1154481arrayals
array86317142array__
arrayed11117152arrayed
arrayer10136702arrayer
arrays95311682array_s
arrival1037562arrival
warragal1243862warragal
abaya104413173a_baya_
abayas114011703a_bayas
adrenal838263adrenal
aerial64625713aer_ial
aortal65217513aor_tal
arcana8912583arcana_
archaeal13115463archaeal
areal55928733a_r_eal
areaway1335913areaway
argal65023393a_r_gal
argala74712673argala_
argalas84011093argalas
argyll1033643a_rgyll
armada938783armada_
armadas1038173armadas
arousal748633arousal
arrack121110253arra_ck
arracks1387733arracks
arraign845063arraign
arrange838683arrange
arrant6623253arra_nt
arrantly1156103arrantly
arras55626133arr__as
arrased8149863arrased
arrases71214543arrases
arrayers11125853arrayers
arraying1238753arraying
arrear6310253arr_ear
arrhizal2042953arrhizal
arriba867683arriba_
arrivals1145933arrivals
arroba898663arroba_
arrobas969213arrobas
arroyo936963arroy_o
arroyos1036533arroyos
arsenal739383arsenal
artal55525473a_r_tal
arval86017013a_r_val
aryl75922343a_r_y_l
asrama839193asrama_
asramas938303asramas
astragal945623astragal
atabal839743a_tabal
atrial65418943atr_ial
aural54428963aur__al
auroral7310473auroral
betrayal1343593betrayal
caracal11312513caracal
carryall1343913carryall
ceramal1138843ceramal
craal74117753_cra_al
defrayal1542613defrayal
errata639013errata_
erratas736863erratas
gayal9312713__gayal
graal64316503_gra_al
irreal657833irr_eal
kraal94511823_kra_al
parral85517533parr__al
phrasal1246163phrasal
piraya1167713piraya_
pirayas1277483pirayas
portrayal1442473portrayal
preanal9310713preanal
ramal74622243__ramal
ratal55025113__ratal
raya75224823__raya_
rayah116013503__rayah
rayas85922053__rayas
riyal84413433__riyal
royal85014703__royal
stratal72710603stratal
surroyal1143953surroyal
warragals1343473warragals
warrigal1244313warrigal

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.406440125.6
2DLD Change Limit134027837.01619103.1
3Display Results83830.0461804.3
 (SQL Overall)178691837.46823927.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.