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

52 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
diapsids124475(None) 
diapsid1146701diapsid_
capsids1239332_capsids
diacids1137862dia_cids
diapirs10347642diap_irs
diopside1245642diopside
diopsides1345282diopsides
aphids125110843__aphids
apsides103911303__apsides
apsis75718293__apsi_s
biopsies1237383biopsies
capsid11312413_capsid_
daisies84217093d_aisies
dassies84418663d_assies
dayside1236173d_ayside
daysides1335963d_aysides
depside1138403d_epside
depsides1238503d_epsides
diacid10310633dia_cid_
dialists9411413dialists
dialysis1245413dialysi_s
diamide1138473dia_mide
diamides1238823dia_mides
diamins10312213dia_mins
diamonds12125173diamonds
diapasons1243203diapasons
diapers104713913diap_ers
diaphysis1844063diaphysi_s
diapir9357113diap_i_r
diaries83321953dia_ries
diarists9410363diarists
diazins1739183dia_zins
diesis74013493di_esi_s
diopsidic1552173diopsidic
dioxids1655683di_oxids
diploids1247843diploids
dipsades1246493di_psades
dipsas9359893di_ps_as
dipshits1445263di_pshits
dipsos95310053di_ps_os
discoids1239873discoids
dispends12308533dispends
dropsies1138693dropsies
elapids1036503elap_ids
gipsies1039903gi_psies
jassids1586143_jassids
lipids94310923li_p_ids
lipoids1038233li_poids
rapids94913893_rap_ids
sialids839723sia_lids
soapsuds1141973soapsuds
synapsids1543223synapsids

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 Filter1786911461620.406440125.6
2DLD Change Limit146162527.06320694.0
3Display Results52520.0301733.3
 (SQL Overall)178691527.49923828.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.