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

153 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
retinites931349(None) 
retinite8314851retinite_
retinitis948011retinitis
melinites11310402melinites
reignites1046932reignites
reincites1148492re_incites
reinvites1287032re_invites
resinates9314762resinates
retinenes9410372retinenes
retines75134672retin__es
retinitides1244732retinitides
retinitises1145972retinitises
retinted94414362retin_ted
retints74717012retin_t_s
retinues85113152retin_ues
reunites8312472re_unites
actinides12188323actinides
arenites8917103are__nites
autunites946193autunites
bentonites1245303bentonites
betonies10413063betoni_es
cotinines11410073cotinines
creatinines1344033creatinines
cretinisms1446703cretinisms
crinites10612753_crinites
cutinises1148513cutinises
cutinizes2047873cutinizes
definite1239323definite_
destinies10410843destini_es
detentes92712863deten_tes
detinues9569823detin_ues
detonates10310423detonates
ebonites1039223_ebonites
felinities1349423felinities
feminines14218173feminines
feminises14229753feminises
feminities1549663feminities
feminizes23238523feminizes
festinates1348933festinates
feticides1547003feticides
fetidities1447873fetidities
finites10315923__finites
gelignites1243583gelignites
geminates12310033geminates
heinies102514543he_ini_es
infinites1258693infinites
kainites1238793_kainites
kernites1269113ke_rnites
latinities10410153latinities
latinizes18610153latinizes
lenites7818443le__nites
lewisites1244213lewisites
meinies92516073me_ini_es
melanites11410723melanites
melilites1149193melilites
melinite10411743melinite_
mutinies10311503mutini_es
patinates113814693patinates
patinizes20710333patinizes
petites93820203pet__ites
pinites9319533__pinites
preinvites1564803pre_invites
preterites12411783preterites
preunites1138933pre_unites
ratanies8312923ratani_es
raticides1248693raticides
ratifies11313513ratifi_es
ratines75328583ratin__es
ratites74920683rat__ites
recites93524583re__cites
rectifies14310813rectifi_es
redenies9615713redeni_es
redingotes1243393redingotes
redivides1445683redivides
refines105426343refin__es
refinishes1644693refinishes
regicides1345813regicides
rehinges1248403rehin_ges
reifies104218283re_ifi_es
reignite947233reignite_
reignited1145683reignited
reincite1089703re_incite_
reincited1246853re_incited
reinter73116843re_in_ter
reinters82614773re_in_ters
reinvite1177753re_invite_
reinvited1386193re_invited
rekindles1443863rekindles
reknits1137073re_knit_s
relines75331323relin__es
reminisces1445243reminisces
reminted113615083remin_ted
remints95117293remin_t_s
rentes65431193re__n_tes
repines94927383repin__es
requisites1964503requisites
requites171511763re_quites
resinate8316773resinate_
resinated10413283resinated
resinifies1346903resinifies
resites74027793re__sites
resonates9412403resonates
respites10513243re_spites
restitutes1057823restitutes
retaliates1049073retaliates
retastes82212903ret_astes
retenes76324623reten__es
reticles103912483reti_cles
reticules1139013reticules
reties65436193ret__i_es
retighten1374773retighten
retightens1453683retightens
retiles74426993ret__iles
retimes95020173ret__imes
retinae75517333retin_ae_
retinals85612963retin_als
retinas74819353retin__as
retine66237333retin__e_
retinene839803retinene_
retinoids1045383retinoids
retinols8419743retin_ols
retint65633443retin_t__
retinting102215253retinting
retinue75414843retin_ue_
retinued95210823retin_ued
retinulas945363retinulas
retirees84611653reti_rees
retires74726213ret__ires
retitles83612593reti_tles
retries74129073ret_ri_es
retunes76918403retun__es
reunite7312713re_unite_
reunited939713re_united
reuniter838323re_uniter
reuniters936423re_uniters
reutilizes1947113reutilizes
revisited1346573revisited
revisits1137423revisit_s
rewrites11311053re_writes
rexines144719153rexin__es
rhinitis1145253r_hinitis
routinizes1946013routinizes
ruinates8311883r_uinates
ruminates11410193ruminates
selenites91312083selenites
sternites9310073sternites
stibnites1144043_stibnites
stipites1039653_stipites
tetanies8513543tetani_es
tetanises979863tetanises
tetanizes1889833tetanizes
titanites997413titanites
uraninites1045613uraninites

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411538.70317079.3
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.92220028.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.