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

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

137 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
sequined1810565(None) 
sequinned1982411sequinned
equine151711572_equine_
equines161811592_equines
esquired18315072esquired
required18156832required
requited18169722requited
seined74023062se__ined
sequenced2144452sequenced
sequin1538522sequin__
sequins1637862sequin_s
squinted1847052s_quinted
squired173710052s_quired
acquired2044043acquired
beelined11277713beelined
beguiled1244443beguiled
beguine1068503beguine_
beguines11127213beguines
declined123910883declined
defined123813823de_fined
destined103312453destined
detained103111643detained
deveined1336673deveined
eloined8149813_eloined
engined9119893_engined
enquired18255793enquired
equaled17166923_equaled
equated171910403_equated
equid154610323_equi__d
equinely2044633_equinely
equinox2343013_equinox
equipped2243073_equipped
equites162212493_equites
ermined10410603_ermined
esquire16376593esquire_
esquires17266203esquires
genuine838373genuine_
inquired18245933inquired
peined94918843pe__ined
quired163711943__quired
quoined1735783__quoined
reclined113613603reclined
recoined113614423recoined
redlined103811233redlined
refined114720003re_fined
regained102111243regained
reined74425523re__ined
rejoined16318593rejoined
relined85321933re_lined
relumined1245363relumined
remained112412893remained
repined104918773re_pined
repugned1235353repugned
requiem1836113requi_em
requin15310713requin__
requins16310203requin_s
require16148653require_
requirer17156113requirer
requires17168703requires
requite162012483requite_
requiter17168643requiter
requites171511763requites
reshined123011123reshined
resined84522653re_sined
retained93016093retained
retuned86613973retu_ned
returned9459133returned
ruined74813323__ruined
sained75424243s__ained
sardined10268663sardined
seasoned948113seasoned
secerned1136103secerned
sectioned1246523sectioned
secund937103secu_n_d
secured1059723secu_red
seduced1186753sedu_ced
segued838513segu__ed
seine55732873se__ine_
seiner64622483se__iner
seines65029903se__ines
seised74218123se__ised
seized164313653se__ized
sentinel838703sentinel
sequel1556713sequ__el
sequelized2963363sequelized
sequence1946903sequence
sequencer2044573sequencer
sequences2067013sequences
sequency2244493sequency
sequent16410323sequen_t
sequents1756993sequents
sequining1945323sequining
sequitur1742973sequitur
serifed11811463se_rifed
serine65432673se_rine_
serines74229543se_rines
serried82513963serri_ed
serviced1435613serviced
sestine73017923sestine_
sestines82717243sestines
setline7313923setline_
setlines8312743setlines
shined104620783s__hined
shrined114112413s_hrined
shunned11417843s_hunned
skeined1236773s_keined
sluiced1046053s_luiced
spavined1434333spavined
spined95423943s__pined
splined105013113s_plined
sprained1138433sprained
spurned10339263s_purned
squared173610553s_quared
squibbed2283413s_quibbed
squid154211903s_qui__d
squidded2043713s_quidded
squiffed2433723s_quiffed
squinch2134833s_quinch
squinched2443083s_quinched
squinnied1942673s_quinnied
squinny19274213s_quinny
squint154214793s_quin_t
squinter1747353s_quinter
squints16339033s_quints
squinty19287053s_quinty
squire155912453s_quire_
squires163812833s_quires
squirmed2034163s_quirmed
squirted1845783s_quirted
squished21186383s_quished
stained84215343s_tained
strained9412253strained
stunned8358893s_tunned
suited74019423s__uited
sunned74216323s__unned
swouned11366663swou_ned
veined104413913ve__ined

Search took 9 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621378.29617618.4
3Display Results1371370.1101245.5
 (SQL Overall)1786911378.57620836.2
 
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.