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

124 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
peised9481768(None) 
peined94918841peined
peise75825771peise_
peises84125041peises
poised94918471poised
prised94322201prised
seised74218121seised
axised14438962axised
ceased94920782ceased
ceiled94114952ceiled
censed94016322censed
cessed94615612cessed
deiced104214482deiced
demised113613682demised
devised123712562devised
eased65430402_eased
feased105718712feased
fessed104515062fessed
guised84612172guised
heiled104415612heiled
heired103813042heired
heisted113210652heisted
hoised105117432hoised
irised73913152irised
jessed144112302jessed
leased74722882leased
lensed74015472lensed
mensed93916542mensed
messed95018182messed
noised75416232noised
paiked135113432paiked
pained95622852pained
paired95017522paired
paise75028332paise_
parsed96323892parsed
passed94320942passed
paused95114962paused
peaced115818912peaced
peaked136117402peaked
pealed95322802pealed
pease75231112pease_
peasen84815962peasen
peases85229472peases
peched144915342peched
pecked155019102pecked
peed76239182pe__ed
peeked134314572peeked
peeled94119702peeled
peened94318152peened
peeped113915382peeped
peered93819482peered
peeved124112882peeved
pegged114811902pegged
pelted94617752pelted
pended103819012pended
penises9318192penises
penned94217612penned
pensee8417312pensee
pepped103113392pepped
periled10316302periled
perished14310072perished
perked134617682perked
permed115217342permed
perse75429522perse_
perses85428062perses
perused103112182perused
petted94121522petted
phased124011972phased
physed15386792physed
pieced113912102pieced
pied75035362p_i_ed
piked125623312p_iked
piled85232992p_iled
pined85935322p_ined
piped105123162p_iped
pished124817062p_ished
pissed94816932pissed
pleased103712072pleased
plied85118592pli_ed
poetised1138522poetised
poise75127892poise_
poiser84217242poiser
poises84226542poises
posed85828412p_osed
praised104214812praised
precised133213412precised
premised133013192premised
pressed103317312pressed
prevised143611072prevised
priced115018882priced
prided103618032prided
pried84426862pri_ed
primed115118912primed
prise74632612prise_
prises84133172prises
prissed103311262prissed
prized184415392prized
prosed94921092prosed
pulsed94013722pulsed
pursed95220882pursed
raised76120332raised
reined74425522reined
reived104518132reived
remised103516842remised
reused75419562reused
revised113815482revised
seined74023062seined
seise54727852seise_
seiser65318342seiser
seises64026712seises
seized164313652seized
sensed73918162sensed
speiled104412122speiled
speired103811102speired
speise84614252speise_
speises93813932speises
teased74721152teased
tensed74817832tensed
veiled103714542veiled
veined104413912veined
versed104515512versed
vised95518762_vised
wised95123342_wised
yessed104511162yessed

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 Filter178691825510.1101624463.6
2DLD Change Limit825511242.65631080.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911242.81263545.9
 
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.