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

114 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
spalls8421734(None) 
palls74332561_palls
scalls84218201scalls
smalls84514121smalls
spails84817821spails
spales84728101spales
spall74919301spall_
spells84617681spells
spills84717461spills
stalls64019931stalls
alls46740922__alls
appalls11337742appalls
balls76236412_balls
calls75634732_calls
falls85727652_falls
galls64729322_galls
halls85633782_halls
lalls55324132_lalls
malls76233432_malls
opals75718352opa_ls
pails75833062_pails
pales75753802_pales
pall65039342_pall_
pally105727122_pally
palms94921752_palms
palps94719562_palps
pals66951352_pa_ls
pawls105617662_pawls
pills74130972_pills
polls74627722_polls
psalms1045672psalms
pulls74425052_pulls
sails55738102s_ails
salals65120082s_alals
sales56055592s_ales
sall44544682s_all_
sally85129712s_ally
salols64017872s_alols
salps74423242s_alps
sals46851672s_a_ls
salts55431882s_alts
sauls55128122s_auls
scalds94813692scalds
scales84529312scales
scall74420372scall_
scalps104315232scalps
sculls84613882sculls
seals54839692sea_ls
sells55134432s_ells
sepals85217372sepa_ls
shales94731252shales
shall85024052shall_
shauls94913112shauls
shawls125411972shawls
shells94319522shells
shills94519612shills
sials54227242sia_ls
sills55135992s_ills
skalds11437832skalds
skells105013782skells
skills104313922skills
skulls10429642skulls
small74016262small_
smalts85214892smalts
smells83914742smells
snails64816652snails
snarls64016872snarls
snells64614202snells
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spahis11310382spahis
spail74921552spail_
spaits85017472spaits
spale74929212spa_le
spalled103113132spalled
spaller92713472spaller
spallers102910732spallers
spams94922192spa_ms
spanks124514122spanks
spans74528732spa_ns
spares84834552spares
sparks124616362sparks
spars75431542spa_rs
spas67036722spa__s
spasms10418972spasms
spates85028172spates
spats75031382spa_ts
spawns11577922spawns
spays105520512spa_ys
speels85116392speels
speils84116222speils
spell75020302spell_
spelts84614642spelts
spiels85317952spiels
spiles84227912spiles
spill74821162spill_
splats84817302splats
splays114910872splays
spoils84614532spoils
spools85115912spools
sprawls12176372sprawls
squalls1647312squalls
stales65538292stales
stalks104614552stalks
stall54722352stall_
stills64118572stills
stulls63912982stulls
swails94913122swails
swales93920762swales
swells93913982swells
swills94213362swills
talls55133432_talls
walls85529382_walls

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511142.64031269.3
3Display Results1141140.0303800.0
 (SQL Overall)1786911143.01359306.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.