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 “spall” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

138 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
spall7491930(None) 
pall65039341_pall
sall44544681s_all
scall74420371scall
shall85024051shall
small74016261small
spail74921551spail
spale74929211spale
spalls84217341spalls
spell75020301spell
spill74821161spill
stall54722351stall
all36148232__all
appall10379742appall
ball66043322_ball
call66838672_call
fall75535312_fall
gall56335992_gall
hall75741162_hall
lall45531312_lall
mall64639372_mall
opal66923522opa_l
opals75718352opals
pail66141832_pail
pal56761672_pa_l
pale66055012_pale
palls74332562_palls
pally105727122_pally
palm85331362_palm
palp85828572_palp
pals66951352_pals
paly95835532_paly
pawl95123262_pawl
pill65339462_pill
poll66332132_poll
psalm949272psalm
pull64731662_pull
sail45447162s_ail
sal36462882s_a_l
salal55425702s_alal
sale44959702s_ale
sally85129712s_ally
salol55222142s_alol
salp64534092s_alp
sals46851672s_als
salt45758522s_alt
saul45836522s_aul
scald84818122scald
scale74629142scale
scalls84218202scalls
scalp95217982scalp
scaly104718722scaly
scull75315762scull
seal45654372sea_l
seals54839692seals
sell45840612s_ell
sepal77723002sepa_l
sepals85217372sepals
shale85332832shale
shalt85534492shalt
shaly114322862shaly
shaul85418102shaul
shawl116217572shawl
shell84424122shell
shill85325332shill
sial45938832sia_l
sials54227242sials
sill45545152s_ill
skald104210172skald
skell94915832skell
skill94316722skill
skull94812032skull
smalls84514122smalls
smalt74729332smalt
smell74916232smell
snail57020202snail
snarl54921082snarl
snell54517302snell
spa55730812spa__
space95325672space
spacy125415622spacy
spade84423322spade
spado83713702spado
spae65034322spa_e
spaed85522272spaed
spaes76029972spaes
spahi10311142spahi
spails84817822spails
spait75631602spait
spake114322742spake
spales84728102spales
spalled103113132spalled
spaller92713472spaller
spam85930042spa_m
spams94922192spams
span65234662spa_n
spang84919732spang
spank115919572spank
spans74528732spans
spar65433302spa_r
spare75135562spare
spark114920892spark
spars75431542spars
spas67036722spa_s
spasm94514172spasm
spat66548522spa_t
spate74731582spate
spats75031382spats
spawn107811712spawn
spay96631662spa_y
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
speel74420762speel
speil75618642speil
spells84617682spells
spelt75430192spelt
spiel74623912spiel
spile75230082spile
spills84717462spills
spilt75532222spilt
splat76129342splat
splay105816042splay
spoil75818652spoil
spool75219042spool
sprawl11188062sprawl
squall1538002squall
stale55637102stale
stalk94518002stalk
stalls64019932stalls
still54922082still
stull54916272stull
swail86217162swail
swale85221592swale
swell84815982swell
swill83417372swill
tall47240212_tall
wall76236102_wall

Search took 3 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 Filter178691538000.406440125.6
2DLD Change Limit538001381.76630464.3
3Display Results1381380.0463000.0
 (SQL Overall)1786911382.21880564.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.