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

133 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
spail7492155(None) 
pail66141831_pail
sail45447161s_ail
snail57020201snail
spails84817821spails
spait75631601spait
spall74919301spall
speil75618641speil
spoil75818651spoil
swail86217161swail
ail37171042__ail
assail6610152assail
avail8313882avail
bail65042802_bail
brail75525552brail
drail65020972drail
email74715102email
espial839542espial
fail74840242_fail
flail85316182flail
frail85220212frail
grail64622872grail
hail74839062_hail
jail115529092_jail
kail85131492_kail
mail65543452_mail
nail45838652_nail
opal66923522opa_l
paid75737482_paid
paik105726802_paik
pails75833062_pails
pain65647242_pain
pair66031512_pair
pal56761672_pa_l
pall65039342_pall
pawl95123262_pawl
pial65636702_pial
quail144314362quail
rail46147762_rail
said55742112s_aid
sails55738102s_ails
sain45551292s_ain
sal36462882s_a_l
sall44544682s_all
sapid84720932sapid
saul45836522s_aul
scall74420372scall
seal45654372sea_l
sepal77723002sepa_l
serail64222672serail
shall85024052shall
shaul85418102shaul
shawl116217572shawl
sial45938832sia_l
sigil63515502sigil
slain54923572slain
small74016262small
snails64816652snails
snarl54921082snarl
soil46138832s_oil
spa55730812spa__
space95325672space
spacial1138762spacial
spacy125415622spacy
spade84423322spade
spadix1636112spadix
spado83713702spado
spae65034322spa_e
spaed85522272spaed
spaes76029972spaes
spahi10311142spahi
spahis11310382spahis
spaits85017472spaits
spake114322742spake
spale74929212spale
spalls84217342spalls
spam85930042spa_m
spams94922192spams
span65234662spa_n
spang84919732spang
spaniel948922spaniel
spank115919572spank
spans74528732spans
spar65433302spa_r
spare75135562spare
sparid94016932sparid
spark114920892spark
spars75431542spars
spas67036722spa_s
spasm94514172spasm
spat66548522spa_t
spate74731582spate
spatial9310322spatial
spats75031382spats
spavie113611382spavie
spavin114210652spavin
spawn107811712spawn
spay96631662spa_y
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
speel74420762speel
speils84116222speils
speir75315362speir
spell75020302spell
spic85227432sp_ic
spiel74623912spiel
spik105419712sp_ik
spile75230082sp_ile
spill74821162spill
spilt75532222sp_ilt
spin66231302sp_in
spit65545082sp_it
spiv95917792sp_iv
split75729012split
spoils84614532spoils
spoilt85016592spoilt
spool75219042spool
sprain83614862sprain
sprawl11188062sprawl
sprig85617742sprig
sprit76736402sprit
staid66722082staid
staig65519642staig
stain55727942stain
stair54719942stair
stall54722352stall
swails94913122swails
swain84919052swain
tail45443652_tail
trail55126772trail
vail75432552_vail
wail75238822_wail

Search took 2 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.296603685.8
2DLD Change Limit538001331.59333772.8
3Display Results1331330.0304433.3
 (SQL Overall)1786911331.91993116.7
 
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.