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

49 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
atalaya104482(None) 
atalayas1144781atalayas
abaya104413173__abaya
aliya83713483__aliya
allay85620393a_llay_
allays94313743a_llays
analgia898363analgia
anally9513503anally_
atabal839743ataba_l
atabals938413atabals
ataman81013063atama_n
atamans9710433atamans
ataraxia1544173ataraxia
ataraxy1743983ataraxy
ataxia13179593ata_xia
ataxy1537313ata_xy_
atemoya1242933atemoya
atlas55821583at_la_s
atlatl637873at_latl
azalea1537003azal_ea
balata8614683_balata
catalase1039223catalase
catalpa1136503catal_pa
cattleya1342403cattleya
chalaza2145733chalaza
fatally1339893fatally_
halala94715093_halala
jambalaya2351063jambalaya
kabaya15387123_kabaya
katakana1142433katakana
lavalava1441863lavalava
otalgia844483otalgia
otalgy1035353otalgy_
palapa10310673_palapa
papaya1337503_papaya
pitahaya1641843pitahaya
playa105812943__playa
stalag7310023stala_g
stalags838643stalags
stalky13499303stalky_
tala45938053_tal__a
talar56225383_tala_r
talaria7412523_talaria
talars66021683_talars
talas55935893_tala_s
talky126215683_talky_
tally84526863_tally_
taluka10426773_taluka
tarama8412733_tarama

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 Limit134027496.98319193.3
3Display Results49490.0163062.5
 (SQL Overall)178691497.40524131.1
 
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.