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

467 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
witness10301001(None) 
fitness10299391fitness
wetness10277721wetness
witless103310981witless
witneys13274721witneys
aptness9268572aptness
bigness1038192bigness
dimness1038842dimness
fatness103311292fatness
hipness12277382hipness
hitless103211192hitless
hotness1038612hotness
jitneys17313172jitneys
lioness739102lioness
liteness82213212liteness
patness92912282patness
swiftness1543652swiftness
titaness836722titaness
waeness102512782waeness
waitress1135222waitress
wanness102610682wanness
whatness1435092whatness
whiteness1546482whiteness
wideness12259472wideness
wieners103212482wieners
wigless11359672wigless
wildness1236202wildness
wiliness1139112wiliness
wines85546862wi_ne_s
winless103212282winless
winners104316912winners
winters103720482winters
wiriness1138952wiriness
wiseness112010752wiseness
wites85536962wit_e_s
withers134417752withers
withes124620842withe_s
witnessed13214722witnessed
witnesser12224532witnesser
witnesses12219922witnesses
witney12356842witne_y
wittiness12197222wittiness
woeness1020211542woeness
wryness13113982wryness
acidness1136723acidness
actress948533actress
aidless83612073aidless
aimless93610813aimless
airiness8412213airiness
airless73712043airless
aridness939223aridness
artiness81615403artiness
artless73712513artless
avidness1246113avidness
awayness1443303awayness
badness1039573badness
biasness1035813biasness
bibless11439173bibless
biners85023633bi_ners
bines76946793bi_ne_s
biters83925243bit_ers
bites75641173bit_e_s
bitters94920363bitters
bittiness11228333bittiness
chicness1535593chicness
cines75239683ci_ne_s
citers85022983cit_ers
cites74435593cit_e_s
cithers124315773cithers
cities84524853citie_s
coyness1277323coyness
curtness1037263curtness
cuteness1039673cuteness
daftness1235533daftness
deftness1236303deftness
dewiness1238453dewi_ness
dienes75719903diene_s
digress938323digress
diners75525953di_ners
dines66449153di_ne_s
dinners83915443dinners
dipnets10109033dipnets
direness9311303direness
dirtiness1039473dirtiness
distress9311713distress
dites66339153dit_e_s
dithers114016153dithers
ditsiness1048143ditsiness
ditzes163212423ditze_s
ditziness1945883ditziness
dryness11114783dryness
dueness82310123dueness
dulness8307983dulness
dunness8298983dunness
dwines105013103dwi_ne_s
earwitness1342623earwitness
editress944933editress
evilness1135043evilness
exitless1534883exitless
eyewitness1641473eyewitness
faintness1235833faintness
fairness1136563fairness
farness102912203farness
fastness11238763fastness
fatless103212203fatless
fewness1335003fewness
feyness1334923feyness
fineness11310643fineness
fines86644263fi_ne_s
finesse10187643fi_nesse
finest94321733fi_nest
finless102810783finless
firmness1334743firmness
firstness1245013firstness
fitnesses12219373fitnesses
fitters104517753fitters
fittest102510803fittest
flatness1138153flatness
fulness10248963fulness
gastness9278473gastness
gayness1136843gayness
giantess933893giantess
giftless1245173giftless
ginners84314223ginners
gites65630183git_e_s
glibness1134133glibness
grimness1175993grimness
gutless82610713gutless
harness102413933harness
hatless103813443hatless
highness1536053highness
hiltless11297123hiltless
hinters103719583hinters
hipless12399923hipless
hitters104717593hitters
iciness938863iciness
illness736473illness
inners63919353_inners
innless7288293_innless
inters64328053_inters
items7499613_it_ems
jitney16304623jitne_y
jitters144314473jitters
justness1535323justness
kidneys1533423kidneys
kindness13236653kindness
kines95039133ki_ne_s
kineses113111253ki_neses
kinesis11259593ki_nesis
kinless113310273kinless
kirmess13234313kirmess
kiters105218593kit_ers
kites95432543kit_e_s
kithes135016653kithe_s
kittens11347583kittens
lateness82614073lateness
laxness1436043laxness
lianes63819323liane_s
licitness1145373licitness
lidless8309273lidless
lightness13107433lightness
likeness12229863likeness
liminess10510643liminess
limners93311563limners
limpness1246703limpness
linens64818393li_nens
liners65428853li_ners
lines57054573li_ne_s
linnets739833linnets
lintels73311163lintels
linters73822633linters
lintless82710013lintless
lipless9259553lipless
listless8269263listless
liters65429883lit_ers
litheness1247363litheness
lithest10513913lithest
litres65220393litre_s
litters73422573litters
liveness112411393liveness
lostness837683lostness
lowness1037813lowness
madness10310073madness
matiness102114753matiness
matless93014043matless
meetness1036653meetness
mildness1136523mildness
milnebs11113793milnebs
miners84126633mi_ners
mines75651953mi_ne_s
minters93822473minters
miriness10310463miriness
mistiness111911633mistiness
mistress10310703mistress
miters84328783mit_ers
mites75141803mit_e_s
mithers123516733mithers
mitiest93520053mitiest
mitises9315543mitises
mitoses9312183mitoses
mitres83922073mitre_s
mittens9349883mittens
moistness1146343moistness
mootness1036753mootness
muteness1039013muteness
neatness839153neatness
ness45526563___ness
netless739863netless
newness1035703newness
niceness1039843niceness
niftiness1236363niftiness
nighness1236103nighness
nines55937343ni_ne_s
niters64624213nit_ers
nites55736343nit_e_s
nitres65519333nitre_s
nowness1037033nowness
oddness935313oddness
oiliness8311563oiliness
oldness836403oldness
oneness7512143oneness
pastness102510503pastness
pertness10310093pertness
pines76048863pi_ne_s
pinkness1436513pinkness
pinners93518603pinners
pipiness1238003pipiness
pithiness1437563pithiness
pithless13117023pithless
pitiers93812653pitiers
pities83828083pitie_s
pitiless10127333pitiless
pixiness1736093pixiness
primness1276763primness
quietness1844753quietness
raptness1046733raptness
rawness1038153rawness
redness82012443redness
ribless93410343ribless
richness1337433richness
rifeness1138583rifeness
riftless1136943riftless
rightness13117353rightness
riminess10510093riminess
rimless9369363rimless
rinses64720383ri_nses
ripeness1039363ripeness
rites54442553rit_e_s
ritters74020623ritters
ritzes154812943ritze_s
ritziness1835823ritziness
sadness8310613sadness
saltness82610243saltness
shitless11249243shitless
shyness1344993shyness
sickness1437833sickness
signees83510803signees
signers84714443signers
signets83311503signets
simnels976103simnels
sines55954823si_ne_s
sinews94210623si_news
sinless73014213sinless
sinners74019023sinners
sinters74024083sinters
sites56045433sit_e_s
sithens1039383sithens
sitters74221553sitters
situses72710493situses
siziness1737423siziness
slimness1036523slimness
slitless8268143slitless
slyness1035263slyness
softness1136433softness
stress66616673_stress
swartness1236113swartness
sweetness1245683sweetness
swinneys14264203swinneys
swithers144310533swithers
tacitness1134873tacitness
tartness82210133tartness
tautness8217183tautness
thinness11277163thinness
tidiness938793tidiness
tieless72512563tieless
tightness1386603tightness
tigress836093tigress
tineas64616483ti_neas
tines54848423ti_ne_s
tininess8310633tininess
tinners73717313tinners
tinters74221113tinters
tintless8239863tintless
tipless92610063tipless
titers64526413tit_ers
titfers10318933titfers
tithers104216733tithers
tithes94720213tithe_s
titles63719923title_s
titres64718933titre_s
titters74219623titters
tress55423163__tress
trigness968403trigness
trimness1067563trimness
triteness9310363triteness
tweeness11246403tweeness
twigless1293663twigless
twiners10459633twi_ners
twines94717273twi_ne_s
twitters11296773twitters
unfitness1244843unfitness
vainness1136063vainness
vastness11257293vastness
victress1344523victress
vileness1139983vileness
vines85137643vi_ne_s
vintners1134573vintners
vitalness1245413vitalness
vitesse1044583vit_esse
voidness1235553voidness
votress1035483votress
waistless1235093waistless
waiters104218623wait_ers
wanes85040883w_ane_s
wannest103915003wannest
wanters104420093wanters
wariness11313213wariness
warless104015103warless
warmness1337063warmness
warners103315563warners
wartless11279923wartless
waters95030633wat_ers
wattest102412153wattest
wattless11268723wattless
waviness1437723waviness
waxiness1836723waxiness
wayless13308243wayless
weakness1535353weakness
weaners104613833weaners
webless1237003webless
weiners103913063weiners
weirdness1343593weirdness
wellness1135793wellness
wethers135214693wethers
wetnesses12208213wetnesses
wetters103817753wetters
wettest10239363wettest
whiners134011573whiners
whines125120103whine_s
whininess1535123whininess
whiteners1535243whiteners
whitens13428733whit_ens
whites123919883whit_e_s
whitest133710113whit_est
whiteys16396153whit_eys
whities133113253whitie_s
whitiest14259883whitiest
whitters14359403whitters
wiches144418753wiche_s
wickers164114703wickers
wickets164010943wickets
wickless1736083wickless
widders123512273widders
wideners12257993wideners
widens106212723wi_dens
wides94832823wi_de_s
widest104517003wi_dest
widgets12318453widgets
wiener94513543wiene_r
wienies102213683wienies
wifeless14277483wifeless
wifes114522563wi_fe_s
wifeys15425873wi_feys
wiftiest14279173wiftiest
wiglets113411423wiglets
wilders113513503wilders
wildest113311273wildest
wiles85437873wi_le_s
wiliest103416593wiliest
willers103517913willers
willets104414323willets
wimpiness1635293wimpiness
wincers123415363wincers
winces114819113wi_nces
winceys15395523winceys
winders113721263winders
windiness1337373windiness
windless123310863windless
winds95425603wi_n_ds
wine74953423wi_ne__
wined94434183wi_ne_d
wineless112711173wineless
winery125014283wi_nery
winesap1264443wi_nesap
winesaps1364553wi_nesaps
winesop1264233wi_nesop
winesops1374663wi_nesops
winey115325433wi_ne_y
wingers113921483wingers
wingless122910023wingless
wings95727243wi_n_gs
winiest103419693winiest
winish124212263wi_nish
winkers143517113winkers
winks125325433wi_n_ks
winned104017013winne_d
winner94219933winne_r
winnows1334533winnows
winoes94317013wi_noes
winos84625043wi_n_os
wins75949173wi_n__s
winter94222803winte_r
wintery13399753wintery
wintles103414983wintles
wintriness1345543wintriness
winzes184313053wi_nzes
wipers115416083wi_pers
wipes104827083wi_pe_s
wireless11249633wireless
wirers94617893wi_rers
wires86034913wi_re_s
wiriest103816853wiriest
wiseass1035823wiseass
wisents10249063wisents
wises85633193wi_se_s
wisest95016443wi_sest
wishers133215213wishers
wishes124920953wishe_s
wishless1435993wishless
wispiness1435633wispiness
wiss75630543wi___ss
wisses94619603wisse_s
witans93412933wit_ans
witches152715793witches
wite75443273wit_e__
wited94727143wit_e_d
withe115220233withe__
withed134416233withe_d
wither124321353withe_r
withies133913543withies
withiest142411243withiest
withins133511693withins
witlessly1543743witlessly
witnessers13173103witnessers
witnessing1442443witnessing
wits76044873wit___s
witted104216813witte_d
wittiest112711523wittiest
wittols1035733wittols
wivers125320803wi_vers
wives115328923wi_ve_s
wizens186110263wi_zens
wizes174723343wi_ze_s
wizzens18385483wizzens
wizzes175110773wizze_s
wonners104312813wonners
wornness1136363wornness
writers105513493writ_ers
writes94420333writ_e_s
writhers14398983writhers
writhes134811703writhe_s
wuthers133711523wuthers
wytes114113433wyt_e_s
zinebs17606803zi_nebs
zines145232653zi_ne_s
zipless18276303zipless
zithers193911973zithers

Search took 9 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.670266703.0
2DLD Change Limit1340274677.50017870.3
3Display Results4674670.1732699.4
 (SQL Overall)1786914678.34321418.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.