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 “referents” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
referents1225964(None) 
deferents13269391deferents
referent112813421referent_
afferents1546012afferents
deferent122712872deferent_
deferments16128582deferments
efferents1545332efferents
preferments1844742preferments
recements13312282recements
reerects10319922re_erects
referees111310412refere_es
reference14810092reference
references1589352references
referenda1343072referenda
reforests1245532reforests
refronts1137772ref_ronts
rerents73319422r__erents
reverends13266032reverends
reverent112615092reverent_
adherents1345553adherents
afferent1447983afferent_
befrets1237613bef_re_ts
cerements13411453cerements
decedents1347323decedents
deference1578493deference
deferences1677873deferences
deferment151210303deferment_
deforests1344373deforests
detergents12116663detergents
determents131010313determents
deterrents11126473deterrents
efferent1447203efferent_
elements10312173_elements
emergents1245973_emergents
ferments13311473__ferments
gerents82612923__gerents
leverets11297603levere_ts
precedents1545723precedents
preerects1345413pre_erects
preference1776983preference
preferences1876183preferences
preferment1746323preferment_
reaccents1365853reaccents
reagents959623re_agents
rearrests945313rearrests
reascents1177403reascents
recement12315653recement_
recreants1146623recreants
recrements1449353recrements
redefeats1344203redefeats
redefects1543793redefects
redirects12125103redirects
reejects17336083re_ejects
reelects103110883re_elects
reerect92915883re_erect_
refects124012743ref__ects
refeeds11368973refe_e_ds
refeels10379693refe_e_ls
referee101615753refere__e
refereed12149693refere_ed
referenced1676863referenced
referendum1661613referendum
referendums176943referendums
referential1454683referential
referrals1243493referrals
referrers12125373referrers
refers93921083refer___s
refinements1646793refinements
refires104820313refire__s
reflects13288873ref_lects
reflets103513153ref_le_ts
refluent1147433refluent_
reforest1139963reforest_
reformats1445713reformats
refracts13137383ref_racts
refreezes2153443refreezes
refront10313263ref_ront_
regents83416543r__egents
regiments123910323regiments
regrants9310013re_grants
regreens9257453regreen_s
regreets9287853re_greets
regrets83212923re_gre_ts
reinvents1246123reinvents
relents74018503r__elents
remeets93712413reme_e_ts
reorients997363reorients
repellents1245143repellents
repents93717623r__epents
repetends1244003repetends
represents1246753represents
reprints1039903re_prints
rerent63832453r__erent_
rerepeats1145263rerepeats
reselects1156413reselects
resents74221223r__esents
residents1038423residents
retirants947323retirants
retreats8311413re_treats
revehent14239083revehent_
revelments1546863revelments
revenants1246173revenants
reverence14710163reverence
reverences1579173reverences
reverend12288853reveren_d
reverently1645613reverently
reverers113113153revere_rs
reveres103621343revere__s
revertants13124953revertants
reverts104715043rever__ts
revetments1546433revetments
sederunts1043063sederunts
tenements1149963tenements

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411137.75019179.5
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.95222471.2
 
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.