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 “argylls” 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
argylls114346(None) 
argyles1136051argyles
argyll1033641argyll_
argalas84011082argalas
argalis84214182argalis
argals75517702arg_als
argils75213622arg_ils
argles75218482arg_les
argols74514612arg_ols
argyle1066062argy_le
aryls87015812ar_y_ls
acyls104211523a_cy_ls
alkyls13465723alky_ls
alls46740923a___lls
allyls9437273ally_ls
amyls104512683a_my_ls
angels74416173ang_els
angelus8418463angelus
angles74426703ang_les
anglos74413903ang_los
aphylly1843353aphylly
appalls11337743appalls
arables91814973arables
archils12510533archils
areally10411243areally
areolas71013863areolas
areoles71016953areoles
argal65023383arg_al_
argala74712663arg_ala
argali75013743arg_ali
argents84014853argents
argil65116883arg_il_
argle65421563arg__le
argled85314543arg_led
argol65317263arg_ol_
argons75018203arg_ons
argots74116023arg_ots
arguers8489023arguers
argues74516413arg_ues
argus66716543arg__us
arguses84711743arguses
ariels65119373ar_iels
arils58732203ar__ils
arles56735743ar__les
armfuls1275013armfuls
armilla936993armilla
armillas1046663armillas
aroynts1036633aroynts
arrayals1154483arrayals
artels66216233ar_tels
arugolas944403arugolas
arugulas943913arugulas
aryl75922343ar_y_l_
atolls65511353a_tolls
barbells12368823barbells
bargello1144143bargello
bargellos1243323bargellos
begalls10319163begalls
brills84916293br_ills
carrells10359263carrells
carryalls1443523carryalls
drills74414203dr_ills
drolls75312393dr_olls
frills94414223fr_ills
galls64729323__galls
gargles94214893garg_les
gargoyles1442833gargoyles
ghylls1335143_ghylls
gills64728193__gills
grills74314803gr_ills
gulls65222983__gulls
idylls10425253_idylls
krills104211283kr_ills
nargiles976793nargiles
prills84015613pr_ills
raggles93813283raggles
rills55032713_r_ills
riyals94111083_riyals
rolls55326233_r_olls
royals93711263_royals
trills64319853tr_ills
trolls64613943tr_olls
trulls64110283tr_ulls

Search took 9 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.296603685.8
2DLD Change Limit134027838.25016245.7
3Display Results83830.0302766.7
 (SQL Overall)178691838.57620836.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.