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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
sainted8411424(None) 
fainted114211721fainted
painted104214631painted
sained75424241sain_ed
stinted82914191stinted
tainted83512421tainted
airted74214502_airted
anted66328242_a_nted
baited95319242bai_ted
canted94825782ca_nted
daunted93810192daunted
dinted84419842_dinted
fainter103611052fainter
feinted11379622feinted
flinted114411892flinted
gained84617462gain_ed
gaited84416922gai_ted
glinted9399372glinted
hanted104124312ha_nted
haunted11399732haunted
hinted104318322_hinted
jaunted15418562jaunted
jointed15378502jointed
linted74021822_linted
minted94220582_minted
pained95622852pain_ed
painter93814562painter
panted95024822pa_nted
pointed103813982pointed
printed104016372printed
rained75024602rain_ed
ranted74324702ra_nted
sailed74327762sai_led
saint55147072saint__
saintly1039342saintly
saints65122422saint_s
salted74121202sa_lted
saluted84511712saluted
sanded84920612sa_nded
saned65636272sa_n_ed
sated66238532sa__ted
satiated9311602satiated
saunaed836702saunaed
saunter72913452saunter
sauted74119602sa_uted
scanted104114392scanted
scented102811882scented
seined74023062sein_ed
shifted14359982shifted
shined104620782shin_ed
shinned114310912shinned
shitted114212052shitted
shunted11339782shunted
sifted104313672s_ifted
silted74020012s_ilted
singed85422292s_inged
sinned73818412s_inned
sinter63625922s_inter
sited65130742s_i_ted
skinked11339012skinked
skinned12387292skinned
skirted12388612skirted
skited114313482ski_ted
slainte738542slainte_
slanted83514742slanted
slinked123011382slinked
slitted83513312slitted
spined95423942spin_ed
spirted103913072spirted
spited94820442spi_ted
spitted103912702spitted
splinted11369252splinted
sprinted113411162sprinted
squinted1847062squinted
stained84215342stain_ed
stilted83511472stilted
stinter73614512stinter
stunted83010402stunted
suited74019422sui_ted
swinged123810792swinged
swinked15349032swinked
taunted84310962taunted
tinted74419532_tinted
vaunted11438862vaunted
waisted114210942waisted
waited103819772wai_ted
wanted104319722wa_nted

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 Filter1786911076710.376475242.0
2DLD Change Limit107671873.25033129.5
3Display Results87870.0302900.0
 (SQL Overall)178691873.65648876.1
 
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.