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

130 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
seised7421812(None) 
peised94817681peised
seined74023061seined
seise54727851seise_
seiser65318341seiser
seises64026711seises
seized164313651seized
sensed73918161sensed
axised14438962axised
ceased94920782ceased
ceiled94114952ceiled
censed94016322censed
cessed94615612cessed
deiced104214482deiced
demised113613682demised
devised123712562devised
eased65430402_eased
feased105718712feased
fessed104515062fessed
guised84612172guised
heiled104415612heiled
heired103813042heired
heisted113210652heisted
hoised105117432hoised
irised73913152irised
jessed144112302jessed
leased74722882leased
lensed74015472lensed
mensed93916542mensed
messed95018182messed
noised75416242noised
peined94918842peined
peise75825772peise_
peises84125042peises
poised94918472poised
prised94322202prised
raised76120332raised
reined74425522reined
reived104518132reived
remised103516842remised
reused75419562reused
revised113815482revised
sailed74327762sailed
sained75424242sained
sassed76116172sassed
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seated75131062seated
seed55549482se__ed
seeded84520462seeded
seeled73922092seeled
seemed95117612seemed
seeped94317522seeped
segued838512segued
seidel7311082seidel
seine55732872seine_
seiner64622482seiner
seines65029902seines
seis45542392seis__
seisers73816392seisers
seisin63715122seisin
seism75019022seis_m
seisms84912142seisms
seisor63712342seisor
seize143819502seize_
seizer154114572seizer
seizes154317532seizes
selfed10310912selfed
semises93916552semises
sended85121232sended
sense55526822sense_
sensei64712592sensei
senses63923942senses
sepses84515882sepses
sered65737292se_red
serged84118772serged
serifed11811462serifed
served104616812served
sewed95325162se_wed
sexed136618542se_xed
shied96125492shi_ed
shined104620782shined
sided74825952s_ided
sieged85212712sieged
sieved104611442sieved
siped84927682s_iped
sired66134282s_ired
sises55233832s_ises
sited65130742s_ited
sized155519242s_ized
skeined1236772skeined
skied104417752ski_ed
skited114313482skited
skived14429892skived
sliced94416312sliced
slimed94915122slimed
sliped95417062sliped
smiled93716432smiled
sniped94913482sniped
soiled73822472soiled
soused74822982soused
speiled104412122speiled
speired103811102speired
speise84614252speise_
speises93813932speises
spiced115218312spiced
spied85427712spi_ed
spiked134915552spiked
spiled94621992spiled
spined95423942spined
spired94921862spired
spited94820442spited
stied65723032sti_ed
stiped94517072stiped
sudsed83911372sudsed
suited74019422suited
sussed75015532sussed
swiped123811092swiped
swished14418842swished
swived133610632swived
teased74721152teased
tensed74817832tensed
veiled103714542veiled
veined104413912veined
versed104515522versed
vised95518762_vised
wised95123342_wised
yessed104511162yessed

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.360496363.9
2DLD Change Limit825511303.04627101.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911303.45251764.5
 
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.