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

103 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
swail8621716(None) 
sail45447161s_ail
snail57020201snail
spail74921551spail
swails94913121swails
swain84919051swain
wail75238821_wail
ail37171042__ail
assail6610152assail
avail8313882avail
await85524492await
bail65042802_bail
bewail1189582bewail
brail75525552brail
drail65020972drail
email74715092email
fail74840242_fail
flail85316182flail
frail85220212frail
grail64622872grail
hail74839062_hail
jail115529092_jail
kail85131492_kail
mail65543432_mail
nail45838652_nail
pail66141832_pail
quail144314362quail
rail46147762_rail
said55742112s_aid
sails55738102s_ails
sain45551292s_ain
sal36462882s_a_l
sall44544682s_all
saul45836522s_aul
scall74420372scall
seal45654372sea_l
serail64222672serail
shall85024052shall
shaul85418102shaul
shawl116217572shawl
sial45938832sia_l
sigil63515502sigil
slain54923572slain
small74016262small
snails64816652snails
snarl54921082snarl
soil46138822s_oil
spails84817822spails
spait75631602spait
spall74919302spall
speil75618642speil
spoil75818642spoil
staid66722072staid
staig65519632staig
stain55727932stain
stair54719932stair
stall54722352stall
swab96825312swa_b
swabs105817272swabs
swag87526732swa_g
swage94919562swage
swags94921252swags
swains94513952swains
swale85221592swale
swam96329982swa_m
swami105614522swami
swamis114212292swamis
swamp125015322swamp
swamy136714402swamy
swan76631312swa_n
swang95519722swang
swank125318232swank
swans84625012swans
swap95925432swa_p
swaps104819202swaps
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218832swarm
swart86234642swart
swash116316752swash
swat77244442swa_t
swath115920382swath
swats85726862swats
sway107128232swa_y
sways115518462sways
swell84815982swell
swig85818022sw_ig
swill83417372swill
swim96221392sw_im
swirl84514142swirl
tail45443652_tail
trail55126772trail
twain86313622twain
vail75432552_vail
waif105836742_waif
wails86631482_wails
wain75840192_wain
wair75830052_wair
wait75553692_wait
wall76236102_wall
waul76927312_waul
wawl105321942_wawl

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.0961861364.6
2DLD Change Limit538001031.87328724.0
3Display Results1031030.0462239.1
 (SQL Overall)1786911032.01588680.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.