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 “apteryx” 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
apteryx194238(None) 
apery106517902ap_ery_
apter76120202apter__
apteral9311522apteral
apteria9312912apteria
apteryxes2142552apteryxes
artery9911452artery_
aery77231683a__ery_
after85719793after__
afters94717073after_s
aftertax1843233aftertax
alter54828503alter__
altered83215733altered
alterer72713993alterer
alters64924223alter_s
ambery133811133ambery_
antefix1745053antefix
anthrax1757153anthrax
aper66336233ap_er__
apercu1057383ap_ercu
apers76629133ap_er_s
apex137220213ap_e__x
apiary113910383apiary_
apterium1249133apterium
apterous10410463apterous
aptest82917513apte_st
aptly105111813apt_ly_
aster55434893aster__
asteria7316183asteria
astern64815813aster_n
asters65631603aster_s
battery124911813battery_
cattery123811603cattery_
cautery12349593cautery_
eatery95316353eatery_
japery18439143jap_ery_
mastery124214323mastery_
mattery123810713mattery_
napery11489813nap_ery_
nitery94412173nitery_
papery134812743papery_
pater74740723pater__
paters84935833pater_s
peery105719443_peery_
pterin81014153_pterin
pteryla1243303_pteryla
sphery14318883sphery_
wastery134610993wastery_
watery123914493watery_

Search took 7 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.28321331.7
3Display Results49490.0133769.2
 (SQL Overall)178691496.70226662.3
 
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.