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

310 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
spiffing1723708(None) 
sniffing15227451sniffing
spiffying2142751spiffying
stiffing15248701stiffing
biffing163510012_biffing
coiffing1755932coiffing
miffing16298402_miffing
piaffing1733922_piaffing
piffling1745132_piffling
puffing162910942_puffing
riffing144011272_riffing
scoffing17275942scoffing
scuffing17287112scuffing
shifting152910382shifting
sifting113014592s_ifting
skiffling2043102skiffling
sluffing15247302sluffing
sniffling1644092sniffling
snuffing15256802snuffing
spicing123914532spi_cing
spieling113212522spieling
spiering112713352spiering
spiffied17234822spiffied
spiffier16255882spiffier
spiffies16277992spiffies
spiffily19153482spiffily
spiking144312882spi_king
spiling102919702spi_ling
spilling113113942spilling
spinning113310812spinning
spiring103918182spi_ring
spirting112913632spirting
spiting103917622spi_ting
spitting113012322spitting
spoofing14228362spoofing
staffing15247492staffing
stifling122110912stifling
stuffing15247842stuffing
tiffing14339382_tiffing
whiffing2134702whiffing
aspiring1138873aspi_ring
baffing164011603_baffing
biffin14369103_biffin_
biffins15358533_biffins
bluffing17275493bluffing
boffing16339983_boffing
briefing1436943briefing
buffing163411393_buffing
chaffing2036323chaffing
cheffing2034463cheffing
chuffing2055043chuffing
coffing163811253_coffing
coifing133213893coi_fing
cuffing163210253_cuffing
daffing15369733_daffing
deifying1637633deifying
doffing15357793_doffing
drifting13338733drifting
edifying1636083edifying
feoffing1432963feoffing
fifing134212343_fi_fing
fluffing14275413fluffing
gaffing15379733_gaffing
gifting123810893_gifting
griffin1434513griffin_
griffins1544783griffins
grifting13299263grifting
gruffing1635273gruffing
huffing17278833_huffing
knifing1536483kni_fing
lifting113313273_lifting
luffing143310103_luffing
muffing163210403_muffing
naffing14359033_naffing
offing13368643__offing
opiating11410093opiating
opining10311743opi_ning
ossifying1644253ossifying
picking163418333_picking
piecing12410453_piecing
pieing93917653_pi_eing
pigging123614673_pigging
piing85218833_pi__ing
piking133719643_pi_king
piling95025593_pi_ling
pilling103722563_pilling
pimping143812123_pimping
pinging113419553_pinging
pining93726533_pi_ning
pinking143918943_pinking
pinning103417853_pinning
piping114017453_pi_ping
pipping113414743_pipping
piquing1935873_piquing
pishing134314373_pishing
pissing103914803_pissing
pithing134014053_pithing
pitting103618873_pitting
pitying132910243_pitying
puffin141149003_puffin_
puffins15278913_puffins
quaffing2434353quaffing
reffing143712173_reffing
reifying1539383reifying
riffling1556113_riffling
rifling112815013_rifling
rifting113515003_rifting
ruffing143210843_ruffing
sailing83927373sai_ling
saining83621393sai_ning
sainting93215733sainting
salifying1636333salifying
scarfing14309713scarfing
sclaffing1843363sclaffing
scuffling1843613scuffling
seining84020773sei_ning
seising84018863sei_sing
seizing174114833sei_zing
selfing112911623s_elfing
shafting15278683shafting
sheafing15329483sheafing
shieling123512403shieling
shilling123315383shilling
shimming16278253shimming
shining113816523shi_ning
shinning123211023shinning
shipping163611253shipping
shirking163210473shirking
shirring122910443shirring
shirting123213613shirting
shitting123212663shitting
shroffing1943313shroffing
shuffling1933453shuffling
sibling10814423s_ibling
siccing12319513s_iccing
sicking143720173s_icking
siding83822133s_i_ding
sidling9915423s_idling
sieging92613203s_ieging
sieving112311233s_ieving
siftings12236583s_iftings
sighing123311663s_ighing
signing92713963s_igning
silking123715593s_ilking
siloing83215503s_iloing
silting83320483s_ilting
singing93221423s_inging
sinking123320543s_inking
sinning83918443s_inning
siping94220633s_i_ping
sipping123117433s_ipping
siring75128313s_i_ring
siting74126623s_i_ting
sitting83519633s_itting
sizing163616443s_i_zing
skidding1535463skidding
skiing113610193ski__ing
skilling132911333skilling
skimming17286273skimming
skimping17306243skimping
skinking12299773skinking
skinning13327893skinning
skioring13237223skioring
skipping17297603skipping
skirling13249063skirling
skirring13297143skirring
skirting13289393skirting
skiting123812503ski_ting
skiving15298373ski_ving
slicing103514643sli_cing
slicking153712593slicking
sliding93114553sli_ding
sliming102913953sli_ming
slimming13288093slimming
slinging103312863slinging
slinking133412983slinking
sliping103314413sli_ping
slipping133510663slipping
slitting93012583slitting
smiling103915443smi_ling
smirking15277233smirking
smiting103014443smi_ting
snaffling1643763snaffling
snafuing1235083snafuing
snarfing12358663snarfing
snibbing13295893snibbing
snicking153610233snicking
sniffier14356643sniffier
sniffily17154033sniffily
sniffish1744513sniffish
sniping103712053sni_ping
snipping13308853snipping
snuffling1643563snuffling
soiling83422323soi_ling
sopiting11310763sopi_ting
spacing123614493sp_acing
spading113114383sp_ading
spaeing103413543sp_aeing
spalling113213463spalling
spamming15317603spamming
spanking153911973spanking
spanning113311083spanning
sparging122611133sparging
sparing104823873sp_aring
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spasming13227203spasming
spatting113111763spatting
spawning14296913spawning
spaying133014623sp_aying
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
speccing15306643speccing
specifying2144683specifying
specking17359733specking
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spending122712433spending
spewing133110453sp_ewing
sphering142811943sphering
spiff133616403spiff___
spiffed16257103spiff_ed
spiffiest17235663spiffiest
spiffiness1842983spiffiness
spiffs14328473spiff__s
spiffy17326223spiff__y
spilings11308813spi_lings
spindling13136273spindling
spinnings12294853spinnings
spiraling1237953spiraling
spiriting1238413spiriting
spitfire1343053spitfire
splaying14219303splaying
splicing1338963splicing
splining11310773splining
splinting1238193splinting
splitting1236563splitting
spoiling112911553spoiling
spoking143212223sp_oking
sponging1238823sponging
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
sporing104319413sp_oring
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
spraying14299883spraying
sprigging1435893sprigging
spring94526013sp__ring
springing1338743springing
sprinting12310033sprinting
spritzing2135393spritzing
sprucing1336893sprucing
spudding1335653spudding
spuing94313363sp__uing
spuming1248523sp_uming
spunking15258063spunking
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
spying123913253sp__ying
sticking153513463sticking
stiffen13286023stiffen_
stiffening1742113stiffening
stiffens14244113stiffens
stiffie13245773stiffi_e
stiffies14258383stiffies
stiffish1745243stiffish
stilling93415323stilling
stilting93312403stilting
stimying1437503stimying
stinging103213453stinging
stinking133113543stinking
stinting93415743stinting
stirring9299653stirring
strafing122111193strafing
stuffings16233493stuffings
suiting83419003sui_ting
surfing112914483s_urfing
swigging14337223swigging
swilling123511933swilling
swimming16316323swimming
swinging133411113swinging
swinking163410323swinking
swiping13319823swi_ping
swirling12249143swirling
swishing15277813swishing
swiving14358953swi_ving
tariffing1644113tariffing
tiffin12327933_tiffin_
tiffins13327983_tiffins
trifling122411503trifling
typifying2143323typifying
unifying1537553unifying
upfling1337093up_fling
uplifting1534963uplifting
waffing173710243_waffing
waifing142910893wai_fing
whiffling2242883whiffling
wifing133513393_wi_fing
yaffing17337823_yaffing

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.420425454.8
2DLD Change Limit1461623106.89321204.4
3Display Results3103100.1402214.3
 (SQL Overall)1786913107.45323975.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.