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

133 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
centrings1222760(None) 
centerings13247661centerings
centring112112951centring_
centering122915142centering_
centrisms1348052centrisms
centrists11410232centrists
restrings10159292restrings
agentings1134443agent_ings
antings85015583_ant_ings
bantlings12216603bantlings
bearings113912253be_arings
beatings114113233beat_ings
beltings11369253belt_ings
buntings11348773bunt_ings
cannings113710333can_nings
cantering122417373cantering_
cantinas102713783cant_inas
canting104725903cant_ing_
cantrips12318933cantri_ps
castings113614053cast_ings
catlings113712043c_atlings
ceilings11397993ce_ilings
censing104215263cen_sing_
censoring1238783censoring_
censuring1237603censuring_
centerlines1346993centerlines
centiles103615813cent_iles
centimes124012613cent_imes
centimos12507323cent_imos
centones10313663cent_ones
centrals102712033centr_als
centres93817123centr__es
centric11312403centri__c
centrical1348353centrical
centrifuge1652813centrifuge
centrifuges1752873centrifuges
centriole1145673centriole
centrioles1245803centrioles
centrism1249643centri_sm
centrist10314863centri_st
centroids1247053centroids
centrums1236913centr_ums
centuries11311333centuri_es
centurions1255513centurions
cering94522533ce__ring_
chitlings15255903chitlings
cinerins10414103cinerin_s
citrines102513133c_itrines
citrins92614363c_itrin_s
clearings12286063clearings
clothings15264433clothings
coatings113811843coat_ings
colorings1247683colorings
constringe1345853constringe
constringes1445043constringes
contains10316533contain_s
contrives14311703contrives
coverings15217893coverings
craterings1346003craterings
crestings12298043crest_ings
cunnings11357343cun_nings
cuttings11277613c_uttings
decentring1446753decentring_
dentines93418403dent_ines
denting94422183dent_ing_
dentins83419223dent_in_s
dextrines1798313dextrines
dextrins16117823dextrin_s
earings84517713_e_arings
earrings9299633_earrings
eatings84616443_eat_ings
endings92910443_en_dings
endrins8312163_endrin_s
entering91920053_entering_
entrains8312963_entrain_s
entrants8311753_entrants
entries71523163_entri_es
entwines1148753_entwines
enuring8813883_enuring_
estrins7315853_estrin_s
eyestrings1462773eyestrings
feltings12317903felt_ings
fencings14225663fen_cings
fettlings1353753fettlings
gearings10359503ge_arings
gentling1048453gentling_
gentrices1258913gentrices
gentries91315263gentri_es
hearings123611853he_arings
henting113719653hent_ing_
herrings12379533he_rrings
huntings12328053hunt_ings
jestings16368023jest_ings
kennings13315273ken_nings
letterings11226003letterings
lustrings10245553lustrings
mantlings12207233mantlings
meetings11287413meet_ings
mendings12338303men_dings
mentoring1239543mentoring_
metring103215293me_tring_
muntings11289813munt_ings
nestlings1074313nestlings
nettings9288103ne_ttings
neutrinos943823neutrinos
oestrins8312673oestrin_s
outrings92811053_outrings
pettings11349703pe_ttings
renderings12256083renderings
renting84026853rent_ing_
resprings12156253resprings
restring91518783restring_
scantlings1393313scantlings
scenting113212813scent_ing_
sceptring1444273sceptring_
seatings93614303seat_ings
sentries81318053sentri_es
settings93810073se_ttings
settlings1054683settlings
strings84617133__strings
teethings1344233teethings
tentering102313203tentering_
tenting84621153tent_ing_
tenuring938863tenuring_
tintings9288713tint_ings
unstrings1046013unstrings
veneerings1443583veneerings
venting114218093vent_ing_
venturing1337553venturing_
vestings12359143vest_ings
weltings12388203welt_ings
westings12429803west_ings
wettings12348403we_ttings

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.420425454.8
2DLD Change Limit1486411337.83018983.5
3Display Results1331330.0632111.1
 (SQL Overall)1786911338.31321495.4
 
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.