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

189 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
jitneys1731317(None) 
jitney16304621jitney_
witneys13274721witneys
fitness10299392fitness
jitters144314472jitters
kidneys1533422kidneys
witness103010012witness
witney12356842witney_
aptness9268573aptness
barneys12569563barneys
bigness1038193bigness
biners85023633bi_ners
bines76946793bi_ne_s
biters83925243bit_ers
bites75641173bit_e_s
bitters94920363bitters
carneys124310543carneys
chimneys1883643chimneys
chutneys1642323chutneys
cines75239683ci_ne_s
citers85022983cit_ers
cites74435593cit_e_s
cithers124315773cithers
cities84524853citie_s
coneys115218423_coneys
cuteys11569983cut_eys
dickeys17479303dickeys
dienes75719903diene_s
dimness1038843dimness
diners75525953di_ners
dines66449153di_ne_s
dingeys12458403dingeys
dinkeys15507263dinkeys
dinners83915443dinners
dipnets10109033dipnets
dites66339153dit_e_s
dithers114016153dithers
ditzes163212423ditze_s
fatness103311293fatness
fines86644263fi_ne_s
fitters104517753fitters
ginners84314223ginners
gites65630183git_e_s
gooneys11407073gooneys
gurneys11406463gurneys
hickeys19508223hickeys
hinters103719583hinters
hipness12277383hipness
hitless103211193hitless
hitters104717593hitters
honeys124016083_honeys
hotness1038613hotness
inners63919353_inners
inters64328053_inters
items7499613_it_ems
janes124928123j_ane_s
jarveys20123413jarveys
jeepneys2041533jeepneys
jennets14517633jennets
jerseys1733243jerseys
jetes124922843jet_e_s
jetways2094053jetways
jibbers18449703jibbers
jibers155912883ji_bers
jibes145520323ji_be_s
jiggers164010183jiggers
jilters144211963jilters
jinkers183511813jinkers
jinks165019333ji_n_ks
jinnee13411573jinne_e
jinnis13489053ji_nnis
jinns126013843ji_n_ns
jins115635013ji_n__s
jinxes20428233ji_nxes
jitter133314993jitte_r
jittery17346443jittery
jivers164515643ji_vers
jives154820813ji_ve_s
jivey185111873ji_vey_
jockeys23365953jockeys
joeys15518043j__oeys
joiners144211573joiners
jointers15289323jointers
jones125028183j_one_s
jotters143413803jotters
journeys1843203journeys
justness1535323justness
jutes125125133jut_e_s
kidney1434763kidney_
kines95039133ki_ne_s
kiters105218593kit_ers
kites95432543kit_e_s
kithes135016653kithe_s
kittens11347583kittens
lianes63819323liane_s
limeys11429273li_meys
limners93311563limners
linens64818393li_nens
liners65428853li_ners
lines57054573li_ne_s
liney87029633li_ney_
linnets739833linnets
linseys1035083linseys
lintels73311163lintels
linters73822633linters
lioness739103lioness
liteness82213213liteness
liters65429883lit_ers
litres65220393litre_s
litters73422573litters
looneys10487013looneys
mateys115610943mat_eys
mickeys18447943mickeys
milnebs11113793milnebs
miners84126633mi_ners
mines75651953mi_ne_s
minters93822473minters
miters84328783mit_ers
mites75141803mit_e_s
mithers123516733mithers
mitres83922073mitre_s
mittens9349883mittens
moneys115513623_moneys
motleys1235683motleys
nines55937343ni_ne_s
niters64624213nit_ers
nites55736343nit_e_s
nitres65519333nitre_s
patness92912283patness
phoneys15437143phoneys
pigsneys1442003pigsneys
pines76048863pi_ne_s
piney105727503pi_ney_
pinkeys16378213pinkeys
pinners93518603pinners
pitiers93812653pitiers
pities83828083pitie_s
rickeys16548983rickeys
ridleys11145783ridleys
rites54442553rit_e_s
ritters74020623ritters
ritzes154812943ritze_s
sawneys13274643sawneys
shinneys14275093shinneys
signees83510803signees
signers84714443signers
signets83311503signets
simnels976103simnels
sines55954823si_ne_s
sinews94210623si_news
sinners74019023sinners
sinters74024083sinters
sites56045433sit_e_s
sithens1039383sithens
sitters74221553sitters
spinneys13335553spinneys
swinneys14264203swinneys
tawneys13324773tawneys
tineas64616483ti_neas
tines54848423ti_ne_s
tinners73717313tinners
tinters74221113tinters
titaness836723titaness
titers64526413tit_ers
titfers10318933titfers
tithers104216733tithers
tithes94720213tithe_s
titles63719923title_s
titres64718933titre_s
titters74219623titters
treys85018213__treys
vines85137643vi_ne_s
vintners1134573vintners
wetness10277723wetness
whiteys16396153whit_eys
wieners103212483wieners
wifeys15425873wi_feys
winceys15395523winceys
wines85546863wi_ne_s
winey115325433wi_ney_
winners104316913winners
winters103720483winters
wites85536963wit_e_s
withers134417753withers
withes124620843withe_s
witless103310983witless
zinebs17606803zi_nebs
zines145232653zi_ne_s
zithers193911973zithers

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271895.86022871.5
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.32628247.1
 
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.