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

239 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
spookier1417549(None) 
spoonier10167651spoonier
hookier143811672_hookier
kookier10398282_kookier
pockier153911602_pockier
pokier124914632_p_okier
porkier133712342_porkier
rookier114012382_rookier
smokier1356702s_mokier
snooker113910302snook_er
snoopier10177272snoopier
snootier8278382snootier
snoozier17185192snoozier
sootier73916612s_ootier
sparkier14298032sparkier
spikier13369982sp_ikier
spongier1135732spongier
spoofer12368722spoo_fer
spooked144510472spook_ed
spookery17264142spook_ery
spookiest15156392spookiest
spookily1744172spookily
spooking15269802spooking
spookish1744642spookish
spooler93711382spoo_ler
spoonies101911752spoonies
sportier102010052sportier
spottier10207312spottier
spunkier14235812spunkier
stockier14217252stockier
stooker113811732stook_er
swoonier11185132swoonier
swoopier13175142swoopier
blockier1666133blockier
bloodier1136823bloodier
bloomier1275783bloomier
booker124719193_book_er
bookie123516003_bookie_
bookies133819403_bookies
boomier113312183_boomier
boozier18349013_boozier
boskier13309173_boskier
broodier1157433broodier
brookie1347373brookie_
brookies1459143brookies
broomier1236873broomier
chokier1638043_chokier
choosier1337173choosier
cockier154013623_cockier
cooker124722453_cook_er
cookie123716043_cookie_
cookies133719273_cookies
corkier133114303_corkier
croakier14436263croakier
crooker134111093crook_er
doomier103610123_doomier
dorkier122810023_dorkier
droolier936073droolier
droopier1145573droopier
flockier1745343flockier
folkier14359043_folkier
footier104115113_footier
forkier144311593_forkier
gloomier1135093gloomier
goofier11339313_goofier
gooier73516213_goo_ier
goonier83612843_goonier
goopier103910573_goopier
goosier83512563_goosier
groovier1233793groovier
hokier134214033__hokier
hoodier113812973_hoodier
hooker134820173_hook_er
hookies144017443_hookies
hootier104915353_hootier
jokier17618753__jokier
kookie9389843_kookie_
looker104816953_look_er
loonier73312683_loonier
loopier93711193_loopier
moodier103212203_moodier
moonier93714103_moonier
moorier93113073_moorier
nookie103712433_nookie_
nookies113414963_nookies
oakier104011393__oakier
oozier153610253__oozier
pawkier16236613_pawkier
peakier134411443_peakier
peckier153910523_peckier
perkier133813123_perkier
peskier13319113_peskier
phonier122710633_phonier
pickier153912973_pickier
podgier11338723_podgier
poker115122883_p_ok_er
pokies125921333_p_okies
poofter1237163_poofter
pooler83819843_poo_ler
poorer82613993_poo_rer
porker124917543_pork_er
porkies133416493_porkies
pornier93413133_pornier
pottier93516493_pottier
poutier93215323_poutier
poxier153812113_p_oxier
prosier93817483_prosier
punkier133512793_punkier
rockier134911883_rockier
rookie103613263_rookie_
rookies113917103_rookies
roomier93812243_roomier
rootier74915393_rootier
sarkier113413313s_arkier
savorier1136643savorier
scooper113812033scoo_per
scooter93312873scoo_ter
shakier143411153s_hakier
shlockier1842583shlockier
shoalier1137073shoalier
shocker163411433shock_er
shoddier1334213shoddier
shooter103013993shoo_ter
showier1339103s_howier
silkier114411643s_ilkier
skankier11184883skankier
skier95119593s___kier
skunkier11174283skunkier
sleekier1245573sleekier
slinkier12206933slinkier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
smirkier1444433smirkier
smoggier1243973smoggier
smoker124311693s_mok_er
smoocher15205503smoocher
smoother13196673smoother
snakier112810003s_nakier
snarkier12336513snarkier
sneakier1245143sneakier
snobbier1234633snobbier
snooked123711493snook_ed
snookers12398653snook_ers
snooking133010583snooking
snooper93511533snoo_per
snoozer16409193snoo_zer
snottier8217383snottier
snoutier8206973snoutier
snowier1038793s_nowier
soaker105717533s_oak_er
soapier93411713s_oapier
soggier93410883s_oggier
soldier82812153s_oldier
sonsier7711743s_onsier
sooner64220463s_oo_ner
soother104215043s_oother
soppier112711583s_oppier
sorrier72313733s_orrier
soupier93111753s_oupier
spacier114011633sp_acier
spanker133612353spank_er
sparker133914363spark_er
sparkler14317983sparkler
sparklier1554363sparklier
sparrier10329143sparrier
speaker133311213speak_er
speedier1146623speedier
spendier1147143spendier
spherier1337783spherier
spicier115112463sp_icier
spier75728033sp___ier
spiffier16255883spiffier
spiker124315663sp_ik_er
spinier93715163sp_inier
spirier93214073sp_irier
spoiler93310683sp_oiler
spoke114818663sp_ok_e_
spoked134413893sp_ok_ed
spoken124610003sp_ok_en
spokes124417213sp_ok_es
spoking143212223sp_oking
sponger1038523sp_onger
spoofed13399103spoo_fed
spoofers13307323spoo_fers
spoofery16354313spoo_fery
spoofing14228363spoofing
spook115416043spook___
spookeries1654293spookeries
spookiness1644433spookiness
spooks124312933spook__s
spooky15418093spook__y
spooled104613523spoo_led
spoolers10349363spoo_lers
spooling113212563spooling
spooned103412443spoo_ned
spooney12418243spoo_ney
spooniest11178133spooniest
spoonily1335233spoonily
spooning112811443spooning
spoor75016353spoo___r
spoored104411293spoo_red
spooring113111463spooring
sporter93616553sp_orter
spotter94514883sp_otter
spouter94213223sp_outer
sprier84119063sp__rier
sprucier1254793sprucier
spumier1137903sp_umier
spunkie13215293spunkie_
spunkies14227583spunkies
spurrier10297693spurrier
stalkier1257073stalkier
stickier14229763stickier
stinkier12278543stinkier
stocker133713083stock_er
stodgier1034223stodgier
stoker104417623s_tok_er
stonier72013793s_tonier
stooked124312303stook_ed
stookers12449793stook_ers
stooking132711143stooking
stoolie739723stoolie_
stoolies8311083stoolies
stooper93813193stoo_per
stormier1036103stormier
stroker114113523strok_er
suckier133613973s_uckier
sulkier113811963s_ulkier
swankier15225503swankier
swooner10358673swoo_ner
swooper12389173swoo_per
wonkier1437423_wonkier
woodier113912063_woodier
woolier103612353_woolier
woozier19347323_woozier
yolkier14336123_yolkier
zooier153411233_zoo_ier
zootier163611173_zootier

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622397.64019131.2
3Display Results2392390.0962489.6
 (SQL Overall)1786912397.89222642.0
 
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.