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

229 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
spoonier1016765(None) 
spookier14175491spookier
spoonies101911751spoonies
swoonier11185131swoonier
goonier83612842_goonier
loonier73312682_loonier
moonier93714102_moonier
phonier122710632_phonier
pornier93413132_pornier
snoopier10177272snoopier
snootier8278382snootier
snoozier17185192snoozier
sooner64220462s_oon_er
sootier73916612s_ootier
spinier93715162sp_inier
sponger1038522sp_onger
spongier1135742spongier
spoofer12368722spoo_fer
spooler93711382spoo_ler
spooned103412442spoon_ed
spooney12418242spoon_ey
spooniest11178132spooniest
spoonily1335232spoonily
spooning112811442spooning
sportier102010052sportier
spottier10207312spottier
stonier72013792s_tonier
swooner10358672swoon_er
swoopier13175142swoopier
bloodier1136823bloodier
bloomier1275783bloomier
bonier84321993__bonier
bonnier94711313_bonnier
boomier113312183_boomier
boonies93422483_boonies
boozier18349013_boozier
broodier1157433broodier
broomier1236873broomier
brownier13226913brownier
caponier1237883caponier
choosier1337173choosier
cornier93017093_cornier
crooner93714043croon_er
doomier103610123_doomier
downier11299703_downier
droolier936073droolier
droopier1145573droopier
footier104115113_footier
gloomier1135093gloomier
goofier11339313_goofier
gooier73516213_goo_ier
goonie73615563_goonie_
goonies83618333_goonies
goopier103910573_goopier
goosier83512563_goosier
groovier1233793groovier
hoodier113812973_hoodier
hookier143811673_hookier
hootier104915353_hootier
hornier103012463_hornier
kookier10398283_kookier
loonie64216453_loonie_
loonies73919543_loonies
loopier93711193_loopier
moodier103212203_moodier
mooner85317833_moon_er
moorier93113073_moorier
oozier153610253__oozier
panier84425503_p_anier
pannier93613353_pannier
peonies93620153_peonies
phonied133710563_phonied
phonies123717513_phonies
pinier84024693_p_inier
pioneer936893_pioneer
pockier153911603_pockier
podgier11338723_podgier
pointer93814933_pointer
pointier1038303_pointier
pokier124914633_p_okier
ponder94521693_p_onder
ponied94920703_p_onied
ponies84833463_p_onies
pontonier1146383_pontonier
poofter1237163_poofter
pooler83819843_poo_ler
poorer82613993_poo_rer
porkier133712343_porkier
pottier93516493_pottier
pouncer113511233_pouncer
pounder103314003_pounder
poutier93215323_poutier
poxier153812113_p_oxier
prosier93817483_prosier
punier84519223_p_unier
punnier93511263_punnier
rookier114012383_rookier
roomier93812243_roomier
rootier74915393_rootier
savorier1136643savorier
saxonies1537913saxonies
schooner1336623schoon_er
scooper113812033scoo_per
scooter93312873scoo_ter
scorner9259763scorn_er
seconder1137183seconder
sheenier11167423sheenier
shinier104113143s_hinier
shoalier1137073shoalier
shoddier1334213shoddier
shooter103013993shoo_ter
showier1339103s_howier
simonies10311113simonies
skinnier1264893skinnier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
smoggier1243973smoggier
smokier1356703s_mokier
smoocher15205503smoocher
smoother13196673smoother
snobbier1234633snobbier
snooker113910303snoo_ker
snooper93511533snoo_per
snoozer16409193snoo_zer
snottier8217383snottier
snoutier8206973snoutier
snowier1038793s_nowier
soapier93411713s_oapier
soggier93410883s_oggier
soldier82812153s_oldier
sonder73623523s__onder
sonnies7315223s_onnies
sonsier7711743s_onsier
sooners73916643s_oon_ers
soother104215043s_oother
soppier112711583s_oppier
sorner64720393s_orn_er
sorrier72313733s_orrier
sounder83315383s_ounder
soupier93111753s_oupier
spacier114011633sp_acier
spaniel948923sp_aniel
spanker133612353sp_anker
spanner94312563sp_anner
sparkier14298033sparkier
sparrier10329143sparrier
spawner12347363spawn_er
speedier1146623speedier
spencer113610973sp_encer
spender103713693sp_ender
spendier1147143spendier
spherier1337783spherier
spicier115112463sp_icier
spier75728033sp___ier
spiffier16255883spiffier
spikier13369983sp_ikier
spinner93912263sp_inner
spinnies103210543spinnies
spirier93214073sp_irier
spleenier1143863spleenier
splinter10329703splinter
spoiler93310683sp_oiler
spondee10310593sp_ondee
sponge939663sp_onge_
sponged1137953sp_onged
spongers1137603sp_ongers
sponges10311043sp_onges
sponsor934973sp_onsor
spoofed13399103spoo_fed
spoofers13307323spoo_fers
spoofery16354313spoo_fery
spoofing14228363spoofing
spooked144510473spoo_ked
spookery17264143spoo_kery
spookiest15156393spookiest
spookily1744173spookily
spooking15269803spooking
spookish1744643spookish
spooled104613523spoo_led
spoolers10349363spoo_lers
spooling113212563spooling
spoon74719443spoon___
spoonbill13112473spoonbill
spooneys13314583spooneys
spoonful1343753spoonful
spoons84116023spoon__s
spoony114111793spoon__y
spoor75016353spoo___r
spoored104411293spoo_red
spooring113111463spooring
sporter93616553sp_orter
spotter94514883sp_otter
spouter94213223sp_outer
sprier84119063sp__rier
springer113311753springer
springier1236023springier
sprinter103810813sprinter
sprucier1254793sprucier
spumier1137903sp_umier
spunkier14235823spunkier
spurner9269653spurn_er
spurrier10297693spurrier
stockier14217253stockier
stodgier1034223stodgier
stoner65823203s_ton_er
stooker113811733stoo_ker
stoolie739723stoolie_
stoolies8311083stoolies
stooper93813193stoo_per
stormier1036103stormier
stronger9349693stronger
sunnier73412153s_unnier
swooned11368593swoon_ed
swooners11336863swoon_ers
swooniest12176293swooniest
swooning12278203swooning
swooper12389173swoo_per
thornier1135323thornier
tonier65520713__tonier
toonie63617993_toonie_
toonies73719883_toonies
twoonie1034423twoonie_
twoonies1155693twoonies
woodier113912063_woodier
woolier103612353_woolier
woozier19347323_woozier
zooier153411233_zoo_ier
zootier163611173_zootier

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622297.54619369.5
3Display Results2292290.0763013.2
 (SQL Overall)1786912298.04522211.4
 
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.