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

409 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
knifers1453708(None) 
knifer13598561knifer_
knifes136210211knife_s
conifers133611702conifers
fifers125414922_fifers
heifers1337932heifers
infers93615442in_fers
kaisers11369272kaisers
kiers95320092k_i_ers
kiters105218582k_iters
knickers13306722knickers
knife1210010132knife__
knifed14528122knife_d
knitters12336622knitters
knives13458552knive_s
knowers1436332knowers
lifers95617842_lifers
niffers13287362_niffers
niters64624202_niters
sniffers14257122sniffers
snifters11318602snifters
snipers93311762snipers
unifiers11237172unifiers
uniters73814172uniters
abiders104011083abiders
aiders74524633_aiders
aimers84621913_aimers
airers64922313_airers
aivers94822323_aivers
aliners74717723aliners
angers75222543an_gers
anglers84014823anglers
animes84719593anime_s
anises64826693anise_s
answers1037043answers
anthers103715203anthers
antlers74014743antlers
aquifers2044393aquifers
bailers94221353bailers
baiters94619303baiters
biders94822803_biders
biers76225223_bi_ers
bikers124517553_bikers
binders103920743binders
biners85023633_biners
bingers104519983bingers
biters83925233_biters
boilers93417063boilers
bribers114111493bribers
briefers1335143briefers
briers85319733bri_ers
briners94315633briners
buffers153310793buffers
ceilers93912533ceilers
chafers154512723chafers
chiders135312943chiders
chimers144515133chimers
ciders94620083_ciders
cinders104617753cinders
citers85022973_citers
clivers123411753clivers
coffers154112693coffers
coilers93619903coilers
coiners93620753coiners
coinfers13349503coinfers
confers124120093confers
conifer123212643conifer_
criers83918583cri_ers
daikers124010313daikers
defers105116943_defers
defiers113913993defiers
deicers103612733deicers
deifiers12348993deifiers
deniers84515183deni_ers
dicers94720743_dicers
differs14339973differs
dikers114418793_dikers
dimers94321093_dimers
diners75525953_diners
dingers94321373dingers
dinners83915433dinners
divers105024963_divers
doffers14359853doffers
driers74516733dri_ers
drifters12417913drifters
drivers114412793drivers
duffers143410093duffers
duikers12369383duikers
edifiers12336673edifiers
eiders74321363_eiders
enders74324053en_ders
enters64425643en_ters
enticers10139093enticers
enviers1036993enviers
epimers11109493epimers
exilers14419733exilers
fibers114717523_fibers
fifer115519973_fifer_
fifes114822393_fife_s
filers94623723_filers
finders113717873finders
fingers113418423fingers
firers94922683_firers
fivers124420923_fivers
fixers165112983_fixers
fliers94417193fli_ers
friers94718933fri_ers
frizers19329553frizers
gaffers14428713gaffers
gainers84214593gainers
gaiters83516533gaiters
gibers95114663_gibers
gingers94118633gingers
ginners84314213ginners
givers104817713_givers
gliders94811843gliders
gnawers11356383gnawers
gofers104711513_gofers
goffers14409213goffers
goiters84014433goiters
golfers114410083golfers
grifters12389233grifters
gripers104011463gripers
guiders94111103guiders
hailers104017263hailers
heifer1238203heifer_
hiders104919653_hiders
hikers135014353_hikers
hinders113718503hinders
hingers113420193hingers
hinters103719573hinters
hirers94518063_hirers
hoofers134513323hoofers
igniters9126223igniters
inchers123912523inchers
inciters103210653inciters
inditers93311043inditers
infer84215033in_fer_
inkers104018833in_kers
inliers73110743inliers
inners63919343in_ners
insiders947753insiders
inters64328043in_ters
inviters11359633inviters
ionizers17257713ionizers
jailers144114043jailers
jibers155912883_jibers
jinkers183511813jinkers
jivers164515643_jivers
joiners144211573joiners
juicers1636153juicers
junipers1733923junipers
kaffirs17325553kaffirs
kafirs13306983k_afirs
kaifs125715643kaif__s
kaiser103610373kaiser_
kashers143914023kashers
keeners113610783keeners
keepers133410983keepers
kefirs13396653k_efirs
keggers13357033keggers
keglers12277773keglers
keirs95313673kei__rs
keisters123212043keisters
kelters113813753kelters
kibeis12469803k_ibeis
kibes115521113k_ibe_s
kickers124013293kickers
kidders13399163kidders
kiefs126112203k_i_efs
kier86526803k_i_er_
kifs116023503k_if__s
kikes85122553k_ike_s
killers114215573killers
kilters113813593kilters
kinder113716843kinder_
kindlers13318483kindlers
kines95039133k_ine_s
kinless113310273kinless
kippers153211423kippers
kirs85831733k_i__rs
kissers114211293kissers
kiter95523213k_iter_
kites95432543k_ite_s
klisters123910483klisters
knackers13286843knackers
knappers16315643knappers
knars94416113kn__ars
knaurs10466963kn_aurs
knavery1733123knavery
knaves13439523knave_s
knawels14344683knawels
knawes13328393knawe_s
kneaders1384713kneaders
kneelers12226213kneelers
kneels10408933kn_eels
knees95114873kn__ees
knifing1536483knifing
knights1545653knights
knishes1438263knishes
knits93914743kni__ts
knitter11348133knitter_
knockers13285733knockers
knollers12255133knollers
knotters12276143knotters
knower1337073knower_
knurs94511153kn__urs
koines10415733koine_s
koshers144811803koshers
kraters114212333kraters
krimmers16315673krimmers
krises105016083krise_s
libers84721433_libers
liers55130403_li_ers
lifer85822153_lifer_
lifters104313773_lifters
ligers75022023_ligers
likers104620913_likers
liners65428843_liners
lingers84223293lingers
linkers114317703linkers
linters73822613linters
liters65429873_liters
livers94927823_livers
loafers10349463loafers
loiters74116613loiters
lucifers1334163lucifers
mailers94420333mailers
maimers113813043maimers
milers84625163_milers
mimers105520183_mimers
mincers113714843mincers
minders103720113minders
miners84126633_miners
minivers1337473minivers
minters93822463minters
misers85025703_misers
miters84328773_miters
mixers154513563_mixers
moilers93615203moilers
monikers1437413monikers
nailers73215893nailers
namers84517333_namers
nicer74618293_nicer_
nickers134415093_nickers
nides65229133_nide_s
niffer12378443_niffer_
niggers93111313_niggers
nines55937343_nine_s
nippers113012613_nippers
niseis63512023_niseis
niter55028973_niter_
nitery94412173_nitery
nites55736343_nite_s
nitres65519333_nitres
nixes124519623_nixe_s
noters64020993_noters
offers12349963_offers
oilers64721193_oilers
onagers838103onagers
osiers63412793osi_ers
paniers94717333pani_ers
piers75926333_pi_ers
pikers124717393_pikers
pilfers1238963pilfers
pincers113916503pincers
pinders103720473pinders
pingers104020733pingers
pinkers134118603pinkers
pinners93518593pinners
pipers104318663_pipers
pliers84715153pli_ers
poisers94214433poisers
prefers123713333prefers
pricers113915063pricers
priers84521193pri_ers
primers114215673primers
prizers183911843prizers
puffers15349203puffers
quivers19298753quivers
raiders84615143raiders
railers74420663railers
raisers73617393raisers
reefers103312593reefers
refers93921083_refers
reifiers11309843reifiers
reivers105117083reivers
ricers84120993_ricers
riders74123903_riders
rifer84721983_rifer_
riflers103512193_riflers
rimers84522553_rimers
ringers83922943ringers
rinsers73815743rinsers
risers64624783_risers
rivers94626543_rivers
rolfers104011813rolfers
roofers105013903roofers
rotifers1136043rotifers
ruiners74213023ruiners
sailers73822313sailers
seiners74219273seiners
seisers73816393seisers
seizers164112503seizers
shiers94921753shi_ers
shifters14319853shifters
shiners104015943shiners
shivers133714833shivers
sifters103714783_sifters
singers83824693singers
sinkers113618543sinkers
sinners74019013sinners
sinters74024073sinters
sivers95324153_sivers
sizers155215813_sizers
skiers104713693ski_ers
skinkers11298173skinkers
skinners12347283skinners
skivers14409693skivers
slicers94114923slicers
sliders83515223sliders
slivers104115253slivers
smilers94113843smilers
smiters93414363smiters
snarers74216663snarers
sneers64016173sn_eers
snickers143010963snickers
snider74413913snider_
sniffer13318903sniffer_
snifflers15275043snifflers
sniffs12378843snif_fs
snifter10349623snifter_
sniggers10317093sniggers
sniper84413643sniper_
snipes83917393snipe_s
snippers12299713snippers
snivels10336903snivels
snorers74313793snorers
snuffers14326913snuffers
spicers113815553spicers
spiders103914413spiders
spiers84421743spi_ers
spikers135311993spikers
stiflers11238823stiflers
stivers103613533stivers
suffers133113543suffers
suiters73618873suiters
surfers103614133surfers
swifters14277483swifters
tailers73720183tailers
telfers10299073telfers
tiers55526523_ti_ers
tigers75616503_tigers
tilers63523493_tilers
timers84420993_timers
tinders84219173tinders
tinkers113517143tinkers
tinners73717303tinners
tinters74221103tinters
titers64526403_titers
titfers10318933titfers
toilers74116263toilers
triers64321523tri_ers
triflers113110213triflers
trimers94615143trimers
twiers95410163twi_ers
twiners10459633twiners
twofers1364053twofers
undoers82910573undoers
unifier102211863unifier_
unifies102714713unifies
uniform1247053uniform
uniforms1355033uniforms
uniter64619143uniter_
unites65024853unite_s
universe1145253universe
unmiters1037073unmiters
veilers103911823veilers
veiners104112523veiners
viers85621953_vi_ers
vinifera1443453vinifera
viniferas1542823viniferas
vipers114914533_vipers
vivers124717363_vivers
voicers12348993voicers
voiders11279823voiders
wafers124316143_wafers
wailers103916803wailers
waiters104218623waiters
waivers133410053waivers
weiners103913063weiners
whiffers2064493whiffers
whiners134011573whiners
wifes114522563_wife_s
wifeys15425873_wifeys
wincers123415363wincers
winders113721263winders
wingers113921473wingers
winkers143517113winkers
winners104316903winners
winters103720473winters
wipers115416083_wipers
wirers94617893_wirers
wivers125320803_wivers
wolfers13409633wolfers
woofers133810583woofers
writers105513493writers
zaffers22386773zaffers
zingers173514843zingers

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274097.29618369.9
3Display Results4094090.1432860.1
 (SQL Overall)1786914097.59523527.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.