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

112 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
centrums123691(None) 
centrum1168601centrum_
centums11398781cent_ums
antrums969172_antrums
centaurs1035732centaurs
centrals102712032centrals
centres93817122centr_es
centrism1249642centrism
centrisms1348052centrisms
centum104012362cent_um_
chetrums1543912chetrums
estrums9208602_estrums
oestrums10156472oestrums
tantrums1045112tantrums
antrum8611313_antrum_
canthus1248713canthu_s
cantraps12319113cantraps
cantrips12318933cantrips
cantus85117763cant_u_s
ceintures1136733ceintures
cementums1543293cement_ums
censures102211623censures
census84310303cen_su_s
centals94317053cent_als
centares102913893centares
centas85020703cent__as
centaur935783centau_r
centaury1343953centaury
centavos1344783centavos
centers94420603cent_ers
centeses1079443centeses
centesis1058143centesis
centigrams1543083centigrams
centiles103615813centiles
centime114513033cent_ime
centimes124012613centimes
centimo11609543cent_imo
centimos12507323centimos
centners1057243centners
centones10313663centones
centos85920463cent__os
centra84113883centr__a
central93114473centr_al
centre84316643centr__e
centred103411683centr_ed
centric11312403centr_ic
centring112112953centring
centrings12227603centrings
centrist10314863centrist
centrists11410233centrists
centroid1159313centroid
centroids1247053centroids
cents74730333cent___s
centu76119413cent_u__
centuries11311333centuries
century1237193cent_ury
cerebrums1542913cerebrums
ceriums1139483ce_riums
cesiums1136303ce_siums
cestus84412913cest_u_s
chetrum1445343chetrum_
citrus83610923c_itru_s
coenurus1044133coenuru_s
coniums11311863con_iums
construes11410133construes
contours1039653contours
contras93015623contr_as
controls10311393controls
cundums1235183cun_dums
cuprums1334453c_uprums
decorums1344993decorums
dentures9312453dentures
diestrums1244423diestrums
electrums1344483electrums
engrams1038073_engrams
entraps9109763_entraps
entrees71813773_entrees
entries71523163_entries
entrust7410883_entrust
entrusts847113_entrusts
estrum81810513_estrum_
estrus61912113_estru_s
ferrums1265983fe_rrums
gentries91315273gentries
lustrums1044663lustrums
mantrams12288963mantrams
menstruums1451903menstruums
mentum104511713ment_um_
nontrump1243183nontrump
nostrums1045693nostrums
oestrum9177783oestrum_
oestrus7169583oestru_s
omentums1243973oment_ums
pantoums1236713pantoums
plectrums1553033plectrums
rectums11338523rect_ums
retrims93612373re_trims
rostrums1046093rostrums
sentries81318063sentries
septums1135743sept_ums
serums83916303se__rums
sistrums1055323sistrums
spectrums1543173spectrums
strums84716453__strums
tantrum946683tantrum_
tectums11306423tect_ums
untrims938613_untrims
untruss736553_untruss
ventrals112910003ventrals
ventures11311493ventures
venturis1138193venturis
veratrums1443343veratrums

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621127.45319611.2
3Display Results1121120.0333393.9
 (SQL Overall)1786911127.89222642.0
 
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.