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

209 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
centrals10271203(None) 
centals94317051cent_als
central93114471central_
ventrals112910001ventrals
cantals93919572cant_als
cantraps12319112cantraps
cental84420962cent_al_
centares102913892centares
centas85020702cent_a_s
centra84113882centra__
centraler1146682centraler
centralest1247142centralest
centralise1269602centralise
centralism1448642centralism
centralist12511062centralist
centrally1448902centrally
centres93817122centr_es
centrums1236912centrums
citrals91111672c_itrals
contrails11410542contrails
contras93015622contra_s
controls10311392controls
dentals83915392dent_als
enthrals11278902_enthrals
entrails8310162_entrails
entraps9109762_entraps
generals9109342generals
neutrals846282neutrals
peytrals1355492peytrals
rentals74017482rent_als
ventral103612172ventral_
acetals93411353ace_t_als
antral65719413_antral_
astrals75515243_astrals
australs8359533australs
bentgrass1242963bentgrass
benthal1247963benthal_
betrays12127823be_trays
caltraps12327253caltraps
canals84421673can__als
cantal84122033cant_al_
cantala94114673cant_ala
cantalas104013523cant_alas
canthal12410053canthal_
cantraip12326393cantraip
cantraips13255273cantraips
cantrap113310283cantra_p
cantrips12318933cantrips
caporals1238923caporals
censual937663censual_
centai84814783cent_a_i
centare93113703cent_are
centaur935783cent_aur
centaurs1035733centaurs
centavo1245103cent_avo
centavos1344783centavos
centers94420603cent_ers
centeses1079443centeses
centesis1058143centesis
centiare1067203centiare
centiares1167653centiares
centigrams1543083centigrams
centile94217183cent_ile
centiles103615813centiles
centimes124012613centimes
centimos12507323centimos
centners1057243centners
centones10313663centones
centos85920463cent__os
centralised1446603centralised
centralises1349293centralises
centralisms1547403centralisms
centralists1348143centralists
centrality1547743centrality
centralize2149963centralize
centralizes2249423centralizes
centre84316643centr__e
centred103411683centr_ed
centric11312403centr_ic
centrical1348353centrical_
centring112112953centring
centrings12227603centrings
centriole1145673centriole
centrioles1245803centrioles
centrism1249643centrism
centrisms1348053centrisms
centrist10314863centrist
centrists11410233centrists
centroid1159313centroid
centroids1247053centroids
centrum1168603centr_um
cents74730333cent___s
centums11398783cent_ums
centuple12164043centuple
centuples13134333centuples
centurial1147963centurial_
centuries11311333centuries
ceorls848163ce_or_ls
ceramals1246513ceramals
cereals9313173ce_reals
cerebrals1354833cerebrals
cestas85018543cest_a_s
cesuras958693cesura_s
chlorals13148033chlorals
chorals124614113c_horals
citral81113893c_itral_
conceals123111033conceals
congeals11309863congeals
congrats11311433congrats
construals1245223construals
contra83314703contra__
contract122915633contract
contracts132212013contracts
contrail10410983contrail
contralti1147743contralti
contralto1147093contralto
contraltos1246763contraltos
contrary1347493contrary
contrast102614783contrast
contrasts112211043contrasts
control9310693control_
corals85325143c__orals
corrals93713853c_orrals
costrels1038933costrels
curtals93111623curt_als
denials84114133den_ials
dental74319173dent_al_
dentils84115583dent_ils
dentural948083dentural_
dextral1577003dextral_
dextrans1695983dextrans
dicentras1245473dicentra_s
engrails945383_engrails
engrams1038073_engrams
enrols61213383_en_rols
entails7912823_entails
enteral73516453_enteral_
enthral103410933_enthral_
enthrall11266833_enthrall
enthralls12256133_enthralls
entoils7810733_entoils
entrain7313073_entrain
entrains8312963_entrains
entrant7318873_entrant
entrants8311753_entrants
entrap8710563_entra_p
entreats839773_entreats
entrees71813773_entrees
entries71523163_entries
enwraps1284833_enwraps
estral64716513_estral_
estrays10529403_estrays
extras13310223_extra_s
federals1247303federals
ferals94216643fe__rals
fetials103711743fe_tials
fewtrils1443203fewtrils
funerals1146453funerals
general81010943general_
genitals937243genitals
gentians937563gentians
gentries91315273gentries
inthrals11258503_inthrals
kestrels1235813kestrels
lentils73912973lent_ils
lethals1038113le_thals
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantra_s
menials94015693men_ials
menorahs1346543menorahs
mental84521603ment_al_
menthols1347043menthols
metals84520893me_t_als
minerals10311393minerals
mistrals101212633mistrals
neutral737923neutral_
pectorals13128153pectorals
pentads1039523pent_ads
pentyls1236523pent_yls
petals84719813pe_t_als
petrale9312623pe_trale
petrales10312983pe_trales
petrels9279373pe_trels
petrols92913083pe_trols
peytral1287503peytral_
peytrels1363373peytrels
renewals1137283renewals
rental63922033rent_al_
restorals978073restorals
retral64419743re_tral_
retrials8510823re_trials
sceptral1244513sceptral_
sendals81912273sen_dals
senoras72714953senora_s
sentries81318063sentries
severals1137593severals
tantras73112093tantra_s
tendrils946443tendrils
tertials8510073tertials
tetrads82910193te_trads
tetras63017623te_tra_s
tetryls1034643te_tryls
ventails1139823ventails
ventrally1547253ventrally
vestals104612333vest_als
vestral104111013vestral_
yantras10259003yantra_s
yentas94614213yent_a_s

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.423422437.4
2DLD Change Limit1461622097.67319048.9
3Display Results2092090.0762750.0
 (SQL Overall)1786912098.17221866.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.