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

216 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
pitiless1012733(None) 
pithless13117021pithless
hitless103211192hit_less
pathless13138042pathless
pileless1088622pileless
pipeless12107662pipeless
pipiness1238002pipiness
pithiness1437562pithiness
pitiers93812652piti_ers
pities83828082piti_e_s
pitilessly1542872pitilessly
pixiness1736092pixiness
witless103310982wit_less
aidless83612073ai_dless
aimless93610813ai_mless
airiness8412213airiness
airless73712043ai_rless
artiness81615403artiness
artless73712513art_less
bathless13127383bathless
bibless11439173bi_bless
bittiness11228333bittiness
bodiless1135913bodiless
cities84524853citi_e_s
citizens1943983citizens
citoles9312553citole_s
civilness1444223civilness
dateless9259963dateless
dirtiness1039463dirtiness
ditsiness1048133ditsiness
ditziness1945883ditziness
exitless1534883exit_less
faithless1543903faithless
fatless103212203fat_less
filmless1344553filmless
finless102810783fi_nless
fireless112810593fireless
fishless1436413fishless
fitness10299393fit_ness
gateless9279953gateless
giftless1245173giftless
gutless82610713gut_less
hatless103813443hat_less
hideless12278713hideless
hiltless11297123hiltless
hipless12399923hi_pless
hiveless14227933hiveless
iceless9219963_iceless
iciness938863_iciness
inkless11348713_inkless
innless7288293_innless
ireless72312243_ireless
kindless13289243kindless
kingless13288693kingless
kinless113310273ki_nless
kittles113012493kittle_s
kittlest12297573kittlest
lidless8309273li_dless
lifeless11228143lifeless
limbless12246313limbless
limeless10249663limeless
liminess10510643liminess
limitless1142943limitless
lineless82711943lineless
lintless82710013lintless
lipless9259553li_pless
listless8269263listless
liteness82213213liteness
littles73212783little_s
littlest8309243littlest
mateless102711293mateless
matiness102114743matiness
matless93014043mat_less
milkless1434773milkless
mindless11319443mindless
miriness10310463miriness
mirthless1443353mirthless
mistiness111911633mistiness
mitiest93520053miti_est
mitises9315543mitise_s
motiles93317433motile_s
nathless11127023nathless
netless739863net_less
niftiness1236363niftiness
nitriles8269923nitrile_s
noteless839403noteless
oiliness8311563oiliness
outbless1037963outbless
painless10108343painless
paneless102611763paneless
pantiles103617153pantile_s
passless10247223passless
pastiness112312353pastiness
pastless102411203pastless
patines95225763patine_s
patness92912283pat_ness
peakless14236673peakless
peerless1037503peerless
pegless1038053p_egless
peltless10267373peltless
penniless1144013penniless
petioles10311633petiole_s
petites93820203petite_s
pettiness1178703pettiness
pettles93916483pettle_s
pickiness1737623pickiness
pickles153215443pickle_s
piddlers12359593piddlers
piddles114314273piddle_s
pieties9419223pieti_e_s
piffles15368763piffle_s
pigginess1375453pigginess
piglets103311793pi_glets
piles74742613p__ile_s
pileus84514943p__ileus
pilotless1143993pilotless
pilules9510623pilule_s
pimples133012423pimple_s
piniest93121133pini_est
pinites9319533pinite_s
pinkness1436513pinkness
pinoles93418703pinole_s
pintles94118723pintle_s
piolets93513193pi_olets
pipiest113114493pipi_est
pistils93314303pistil__s
pistoles102514723pistole_s
pitchers153211483pitchers
pitches143617753pitche_s
pithiest132711443pithiest
pitied94017253piti_e_d
pitier84019823piti_e_r
pitifulness1665463pitifulness
pixies154915513pixi_e_s
pizzles17329273pizzle_s
planless1036813planless
playless1334863playless
plotless10256793plotless
plugless1133863plugless
poetless1038723poetless
pointless1135693pointless
pokiness14219863pokiness
poleless1089873poleless
popeless1288473popeless
portless10310643portless
pottiness1179693pottiness
pottles93816983pottle_s
prebless1236823prebless
priceless1336883priceless
printless1137513printless
pulpless12224953pulpless
pumpless14236373pumpless
puniness101610273puniness
puttyless1442013puttyless
retiles74426993retile_s
ribless93410343ri_bless
riftless1136943riftless
riminess10510093riminess
rimless9369363ri_mless
rindless92510193rindless
riskless1235763riskless
ritziness1835823ritziness
ruthless1135413ruthless
rutiles74315843rutile_s
shitless11249243shit_less
sighless1276553sighless
similes92915233simile_s
sinless73014213si_nless
siziness1737423siziness
slitless8268143slit_less
spiceless1335923spiceless
spiciness1347053spiciness
spikiness1536313spikiness
spineless1136133spineless
spininess1137963spininess
spinless10238703spi_nless
spiritless1243743spiritless
spittles1038333spittle_s
spotless1037043spot_less
stiles64328763_stile_s
tideless9269083tideless
tidiness938793tidiness
tieless72512563ti_eless
tilers63523493__tilers
tiles55542103__tile_s
timeless10239543timeless
tininess8310633tininess
tintless8239863tintless
tipless92610063ti_pless
tireless82510263tireless
titaness836723titaness
titles63719923tit_le_s
tittles73413253tittle_s
uppitiness1442753uppitiness
viceless1337983viceless
victimless1751813victimless
viewless1434033viewless
vistaless1254573vistaless
vitalness1245413vitalness
vittles103211113vittle_s
voteless1137493voteless
wattless11268723wattless
wickless1736083wickless
wifeless14277483wifeless
wigless11359673wi_gless
wiliness1139113wiliness
windless123310863windless
wineless112711173wineless
wingless122910023wingless
winless103212283wi_nless
wireless11249633wireless
wiriness1138953wiriness
wishless1435993wishless
witness103010013wit_ness
wittiness12197223wittiness
zipless18276303zi_pless

Search took 10 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.1701051123.5
2DLD Change Limit1461622169.29615723.1
3Display Results2162160.0932322.6
 (SQL Overall)1786912169.55918693.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.