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

210 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
pelvises133727(None) 
clevises1336902clevises
devises114116762de_vises
parvises133911912parvises
pavises125315492p_avises
peavies122213402peavi_es
peises84125042pe__ises
pelisse967062pel_isse
pelisses1048482pelisses
pelites93821992pel_ites
pelves114514662pelv__es
pelvics14245642pelvi_cs
pelvis113610322pelvi__s
penises9318192pe_nises
previses133814282previses
revises104220532re_vises
televises1246352televises
advises11138973_advises
aegises8311373ae_gises
belies84631053bel_i_es
bellies94023723belli_es
betises94816123be_tises
bevies114017303be_vi_es
cellists1038563cellists
cercises12410933cercises
cerises94722253ce_rises
cervices1537133cervices
cervixes2054603cervixes
cullises103111313cullises
deixises1635693deixises
delaines9312963delaines
delimes10314193del_imes
delists84414173del_ists
dellies83622213delli_es
delouses9310013delouses
delves104917083delv__es
demises103719563de_mises
dermises112512023dermises
derrises93012783derrises
dervishes1644933dervishes
despises1139433despises
devices133212583de_vices
devise104215753de_vise_
devised123712563de_vised
devisee113812713de_visee
devisees12358283de_visees
deviser114212393de_viser
devisers12339863de_visers
egises7312493_e_gises
elapses957663_elapses
elegises9128823_elegises
elides74420693_el_ides
elites66027123_el_ites
ellipses1044343_ellipses
elves85118743_elv__es
elvish1277563_elvis_h
envies9314053_envi_es
evites94916473_e_vites
excises1638933_excises
felines104718073fel_ines
fellies104119743felli_es
felsites1138073felsites
genoises939253genoises
heavies132713873heavi_es
helices12313723hel_ices
helixes1739133hel_ixes
helves124316063helv__es
jellies143816533jelli_es
kellies113516853kelli_es
kelpies13289903kelpi_es
kelvins14106563kelvi_ns
kermises14248313kermises
levies93919863le_vi_es
lewises1039133le_wises
malaises10312333malaises
mavises122812993_mavises
melodises1247603melodises
merises93421423me_rises
nellies73418723nelli_es
nervines112310463nervines
obelises1039103obel_ises
palmists12268813palmists
palsies94420273palsi_es
parises94827183p_arises
parvise124211693parvise_
pastises103616053pastises
pavise114714803p_avise_
paviser12489093p_aviser
pavisers13387443p_avisers
pavisse12546813p_avisse
pavisses13397103p_avisses
peases85229473pe__ases
pectases122411193pectases
pectines121914683pectines
pectizes21229793pectizes
peeries93623023peeri_es
peeves113814873peev__es
peevish1535783peevis_h
peise75825773pe__ise_
peised94817683pe__ised
pelages10714613pel_ages
pelerines11311843pelerines
peles75738083pel___es
pelite84323003pel_ite_
pelletises1246353pelletises
pellicles1344923pellicles
peloruses1145873peloruses
peltasts1035703peltasts
peltless10267373peltless
peltries10313023peltries
pelvic13307553pelvi__c
penalises11912773penalises
penlites10312273penlites
pennies94218813penni_es
pennines103112043pennines
pentoses10312893pentoses
peonies93620153peoni_es
peonisms1238443peonisms
peploses1269473peploses
pepluses1287023pepluses
pepsines1239883pepsines
peptides132610263peptides
peptizes21269853peptizes
perfuses1358663perfuses
perishes13313753pe_rishes
perlites10316363perlites
perries93226603perri_es
perses85428063pe__rses
persists1049183persists
peruses94018163pe_ruses
pervades1437353pervades
pervious1337543pervious
petites93820203pe_tites
phthises1645723phthises
plaices11411143p_laices
pleases94515483p_leases
plenishes1487083plenishes
plenisms1237963plenisms
plenists1038253plenists
plexuses1734113plexuses
plies74526513p_l_i_es
plisse8368403p_l_isse
plisses94411773p_lisses
pluses83618073p_l_uses
plusses93510693p_lusses
poetises10313953poetises
poises84226543p__oises
polarises11514073polarises
polices113118053pol_ices
polies84034583pol_i_es
polishes13711783pol_ishes
pollices12410753pollices
pollists10910823pollists
poloists10910523poloists
praises94121103p_raises
praxises1739063praxises
precises123218333precises
prelives13310383prel_ives
premises123018273premises
previse123713793previse_
prevised143611073prevised
prises84133173p__rises
privies122414263privi_es
promises122916763promises
provides1439883provides
provisoes1446653provisoes
provisos1336913provisos
pulses83818663pul__ses
pulverises1544483pulverises
pulvinus1343263pulvinus
pyelitises1544853pyelitises
realises82420183realises
relapses1038033relapses
releases8313343releases
relies65036423rel_i_es
relines75331323rel_ines
relishes11311953rel_ishes
relists73817053rel_ists
relives104619443rel_ives
remises93423483re_mises
reprises102615463reprises
reraises8415643reraises
rerises73525883re_rises
reviles104421353re_viles
revise94019743re_vise_
revised113815483re_vised
reviser104114663re_viser
revisers113511933re_visers
revives134715543re_vives
seises64026713se__ises
selkies113513353selki_es
selvages1236513selvages
selves94119613selv__es
semises93916553se_mises
services1338573services
speises93813933spe__ises
supervises1549073supervises
sylvines14215903sylvines
sylvites14225843sylvites
tallises82713263tallises
teleses7313123tel_eses
televise1146063televise_
televised1344243televised
tellies73820503telli_es
tennises82810133tennises
trellises947023trellises
valises103516263val_ises
velites103417303vel_ites
vises84427773___vises
wellies103719073welli_es

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.423422437.4
2DLD Change Limit1461622107.42319690.4
3Display Results2102100.0762763.2
 (SQL Overall)1786912107.92222556.3
 
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.