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

175 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
kewpie1546541(None) 
kelpie12308611kelpie
kewpies16246921kewpies
cowpie133511512cowpie
hempie132410562hempie
kebbie1435812kebbie
kelpies13289902kelpies
kepi105315632ke_pi_
kepis115313362ke_pis
koppie14277882koppie
newbie11135412newbie
newie81813482new_ie
newsie9138222newsie
tawpie11339142tawpie
weepie11258792weepie
aerie54634603ae_rie
bawtie113812143bawtie
beanie83618593beanie
belie75630383be_lie
bewail1189583bewail
beware11313713beware
bewig1138903bew_ig
buppie12288733buppie
cepe84926653ce_p_e
cheapie1437563cheapie
cowpies143314283cowpies
cowrie113814283cowrie
creepie1137483creepie
dawtie103011093dawtie
dearie73319813dearie
despise1038683despise
despite10410123despite
dewier104013463dew_ier
dexie134716893de_xie
dowie94721143dow_ie
eerie55228533_eerie
empire1039323_empire
epee64628503_e_pee
epic86921303_e_pic
espied9359783_espied
espies83716803_espies
ewe66630983_ew__e
expire1538023_expire
eyrie88117833_eyrie
feirie939553feirie
ferlie92814053ferlie
gawsie1038463gawsie
genie66124923ge_nie
hawkie163810093hawkie
heinie92512663heinie
hempier14319003hempier
hippie132811243hippie
howdie13349733howdie
kebbies1537253kebbies
keckle11359423keckle
kedge115513733ke_dge
keep106329823keep__
keeper123811923keeper
keeping144012543keeping
keeps116020283keep_s
keeve124512133ke_eve
kefir12457913ke_fir
keir86217873ke__ir
kelim11912553ke_lim
kellies113516853kellies
keloid11812623keloid
kelp105322803kelp__
kelped13449553kelped
kelping14319193kelping
kelps115116423kelp_s
kelpy145110683kelp_y
kelvin13117323kelvin
kemp126418763kemp__
kemps135012523kemp_s
kempt134318463kemp_t
kente95821073ke_nte
kep96437203ke_p__
kepped15309543kepped
keppen14346573keppen
kepping16268593kepping
keps106027303ke_p_s
kept106232943ke_p_t
kermis124012393kermis
kerne94718223ke_rne
kernite1159473kernite
kerria10339913kerria
kerries113317913kerries
ketene106613003ketene
ketone105014533ketone
ketose105711813ketose
kettle104311613kettle
kevil12399863ke_vil
keypad1633823keypad
keypal1534893keypal
kiddie12359393kiddie
killie104114893killie
kiltie103210963kiltie
kiwi113211803kiw_i_
kiwis12328583kiw_is
kookie9389843kookie
kopje1835273k_opje
koppies153210013koppies
krewe1238193krew__e
kyrie123712903k_yrie
lewis85315843lew_is
lezzie1435333lezzie
magpie1139093magpie
mealie82519813mealie
meanie83718393meanie
meinie82614523meinie
nappie104112263nappie
nellie63614813nellie
newbies12147423newbies
newies91014073new_ies
newsier10147233newsier
newsies101310393newsies
peerie83617893peerie
people10310193people
peppier10268323peppier
perdie94718513perdie
pewee10319973pew_ee
pewit104622793pew_it
pie55457403___pie
potpie103412433potpie
preppie1058093preppie
recipe103414893recipe
repin75324703re_pin
repine85627813re_pine
respire9411543respire
respite9513033respite
retie55735303re_tie
rewake135218463rewake
rewin85623963rew_in
rewire95421413rewire
rewoke1339521223rewoke
rewore938030163rewore
rewove126420083rewove
rewrite10311143rewrite
seepier92912013seepier
selkie102811693selkie
semple103212753semple
sempre102710093sempre
sepia75318673se_pia
sepic94617053se_pic
sewage10310733sewage
skelpit1344943skelpit
swipe105217083_swipe
tawie84819813taw_ie
tawpies12309873tawpies
techie11511723techie
teepee8314363teepee
tekkie934203tekkie
tempi94912203tempi_
temple102811333temple
tenpin8310583tenpin
tentie62521183tentie
tepee74724213te_pee
tepid8314313te_pid
towie85821873tow_ie
townie93312303townie
veepee11311483veepee
veggie1136303veggie
vegie94614513ve_gie
vespid1246083vespid
vespine1237903vespine
wedgie11428373wedgie
weenie92612023weenie
weepier12319273weepier
weepies122811743weepies
wellie92814913wellie
wipe94830283__wipe
yippie13277843yippie
yowie114616453yow_ie
yuppie13297133yuppie
zowie174313843zow_ie

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 Filter1786911127160.453394461.4
2DLD Change Limit1127161757.33015377.4
3Display Results1751750.0463804.3
 (SQL Overall)1786911757.82922824.2
 
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.