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

59 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
apricots127539(None) 
apricot111010181apricot_
haricots1347332haricots
picots104616442_p_icots
tricots9311562_tricots
addicts1176013addic_ts
afrits9311903afri__ts
airshots1145943airshots
alnicos985533alnico_s
aorists74215833aori_sts
aperients1178253aperients
apicals1159923ap_icals
apices104916263ap_ic_es
apomicts1444193apomic_ts
aprons8316993apr__ons
apropos1138843apropo_s
argots74116033a_r_gots
aristos7312373a_ristos
ascots85312513a__scots
astricts1049463astric_ts
auricles10138333auricles
aurists74615783auri_sts
caprices1439893capric_es
capricious1644223capricious
dicots94915793__dicots
griots74713643_gri_ots
haricot12311963haricot_
heriots10312063heri_ots
lyricons1343583lyricons
massicots1343843massicots
papricas1447053papric_as
parrots9312743par_rots
patriots1038053patri_ots
peridots1138323peridots
picot95031013_p_icot_
pilots84018873_p_ilots
pinots85920273_p_inots
pivots115111903_p_ivots
precuts111710473_precuts
pricers113915063_pricers
prices104524543_pric_es
prickets16329083_prickets
pricks144414263_pric_ks
priests93810863_priests
primos104514423_primo_s
prints84320103_pri_nts
prions84317783_pri_ons
priors83914483_pri_ors
prisons9313223_prisons
privets122910053_privets
riots54922013__ri_ots
spigots1037793sp_igots
sprights14167143sprights
sprints94113773spri_nts
sprits85122533spri__ts
taproots1047253tapr_oots
tricot8317753_tricot_
uprights14145313uprights
uproots937143upr_oots

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 Filter1786911461620.436409841.7
2DLD Change Limit146162597.84318636.0
3Display Results59590.0163687.5
 (SQL Overall)178691598.29521542.0
 
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.